schema

vook

Tables

Name	Columns	Comment	Type
demo_term	5	데모 용어	BASE TABLE
demo_term_synonym	3	데모 용어 동의어	BASE TABLE
schema_migrations	2		BASE TABLE
social_user	5	소셜 사용자	BASE TABLE
template_term	5	템플릿 용어	BASE TABLE
template_vocabulary	2	템플릿 용어집	BASE TABLE
term	8	용어	BASE TABLE
users	9	사용자	BASE TABLE
user_info	6	사용자 정보	BASE TABLE
vocabulary	6	용어집	BASE TABLE

Relations

erDiagram

"demo_term_synonym" }o--|| "demo_term" : "FOREIGN KEY (demo_term_id) REFERENCES demo_term (id)"
"social_user" }o--o| "users" : "FOREIGN KEY (user_id) REFERENCES users (id)"
"template_term" }o--|| "template_vocabulary" : "FOREIGN KEY (template_vocabulary_id) REFERENCES template_vocabulary (id)"
"term" }o--|| "vocabulary" : "FOREIGN KEY (vocabulary_id) REFERENCES vocabulary (id)"
"user_info" |o--o| "users" : "FOREIGN KEY (user_id) REFERENCES users (id)"

"demo_term" {
  bigint_20_ id PK
  varchar_100_ term
  varchar_2000_ meaning
  datetime_6_ created_at
  datetime_6_ updated_at
}
"demo_term_synonym" {
  bigint_20_ id PK
  varchar_100_ synonym
  bigint_20_ demo_term_id FK
}
"schema_migrations" {
  bigint_20_ version PK
  tinyint_1_ dirty
}
"social_user" {
  bigint_20_ id PK
  varchar_255_ provider
  varchar_255_ provider_user_id
  bigint_20_ user_id FK
  datetime_6_ created_at
}
"template_term" {
  bigint_20_ id PK
  varchar_100_ term
  varchar_2000_ meaning
  varchar_255_ synonym
  bigint_20_ template_vocabulary_id FK
}
"template_vocabulary" {
  bigint_20_ id PK
  varchar_20_ type
}
"term" {
  bigint_20_ id PK
  varchar_255_ uid
  varchar_100_ term
  varchar_2000_ meaning
  varchar_4000_ synonym
  bigint_20_ vocabulary_id FK
  datetime_6_ created_at
  datetime_6_ updated_at
}
"users" {
  bigint_20_ id PK
  varchar_255_ uid
  varchar_255_ email
  varchar_30_ status
  datetime_6_ registered_at
  bit_1_ onboarding_completed
  datetime_6_ onboarding_completed_at
  datetime_6_ withdrawn_at
  datetime_6_ last_updated_at
}
"user_info" {
  bigint_20_ id PK
  varchar_10_ nickname
  bit_1_ marketing_email_opt_in
  varchar_20_ funnel
  varchar_20_ job
  bigint_20_ user_id FK
}
"vocabulary" {
  bigint_20_ id PK
  varchar_255_ uid
  varchar_20_ name
  varchar_255_ user_uid
  datetime_6_ created_at
  datetime_6_ updated_at
}

Loading

---

Generated by tbls