vocabulary.md

vocabulary

Description

용어집

Table Definition

CREATE TABLE `vocabulary` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uid` varchar(255) DEFAULT NULL COMMENT 'UID',
  `name` varchar(20) NOT NULL COMMENT '이름',
  `user_uid` varchar(255) NOT NULL COMMENT '사용자 UID',
  `created_at` datetime(6) DEFAULT NULL COMMENT '생성일시',
  `updated_at` datetime(6) DEFAULT NULL COMMENT '수정일시',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_vocabulary_uid` (`uid`),
  KEY `idx_vocabulary_user_uid` (`user_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='용어집'

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
id	bigint(20)		false	auto_increment	term		ID
uid	varchar(255)	NULL	true				UID
name	varchar(20)		false				이름
user_uid	varchar(255)		false				사용자 UID
created_at	datetime(6)	NULL	true				생성일시
updated_at	datetime(6)	NULL	true				수정일시

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)
uk_vocabulary_uid	UNIQUE	UNIQUE KEY uk_vocabulary_uid (uid)

Indexes

Name	Definition
idx_vocabulary_user_uid	KEY idx_vocabulary_user_uid (user_uid) USING BTREE
PRIMARY	PRIMARY KEY (id) USING BTREE
uk_vocabulary_uid	UNIQUE KEY uk_vocabulary_uid (uid) USING BTREE

Relations

erDiagram

"term" }o--|| "vocabulary" : "FOREIGN KEY (vocabulary_id) REFERENCES vocabulary (id)"

"vocabulary" {
  bigint_20_ id PK
  varchar_255_ uid
  varchar_20_ name
  varchar_255_ user_uid
  datetime_6_ created_at
  datetime_6_ updated_at
}
"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
}

Loading

---

Generated by tbls