데모 용어
Table Definition
CREATE TABLE `demo_term` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`term` varchar(100) NOT NULL COMMENT '용어',
`meaning` varchar(2000) NOT NULL COMMENT '뜻',
`created_at` datetime(6) DEFAULT NULL COMMENT '생성일시',
`updated_at` datetime(6) DEFAULT NULL COMMENT '수정일시',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='데모 용어'| Name | Type | Default | Nullable | Extra Definition | Children | Parents | Comment |
|---|---|---|---|---|---|---|---|
| id | bigint(20) | false | auto_increment | demo_term_synonym | ID | ||
| term | varchar(100) | false | 용어 | ||||
| meaning | varchar(2000) | false | 뜻 | ||||
| created_at | datetime(6) | NULL | true | 생성일시 | |||
| updated_at | datetime(6) | NULL | true | 수정일시 |
| Name | Type | Definition |
|---|---|---|
| PRIMARY | PRIMARY KEY | PRIMARY KEY (id) |
| Name | Definition |
|---|---|
| PRIMARY | PRIMARY KEY (id) USING BTREE |
erDiagram
"demo_term_synonym" }o--|| "demo_term" : "FOREIGN KEY (demo_term_id) REFERENCES demo_term (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
}
Generated by tbls