template_term.md

template_term

Description

템플릿 용어

Table Definition

CREATE TABLE `template_term` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `term` varchar(100) NOT NULL COMMENT '용어',
  `meaning` varchar(2000) NOT NULL COMMENT '뜻',
  `synonym` varchar(255) DEFAULT NULL COMMENT '동의어',
  `template_vocabulary_id` bigint(20) NOT NULL COMMENT '템플릿 용어집 ID',
  PRIMARY KEY (`id`),
  KEY `fk_template_term_template_vocabulary` (`template_vocabulary_id`),
  CONSTRAINT `fk_template_term_template_vocabulary` FOREIGN KEY (`template_vocabulary_id`) REFERENCES `template_vocabulary` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='템플릿 용어'

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
id	bigint(20)		false	auto_increment			ID
term	varchar(100)		false				용어
meaning	varchar(2000)		false				뜻
synonym	varchar(255)	NULL	true				동의어
template_vocabulary_id	bigint(20)		false			template_vocabulary	템플릿 용어집 ID

Constraints

Name	Type	Definition
fk_template_term_template_vocabulary	FOREIGN KEY	FOREIGN KEY (template_vocabulary_id) REFERENCES template_vocabulary (id)
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
fk_template_term_template_vocabulary	KEY fk_template_term_template_vocabulary (template_vocabulary_id) USING BTREE
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

erDiagram

"template_term" }o--|| "template_vocabulary" : "FOREIGN KEY (template_vocabulary_id) REFERENCES template_vocabulary (id)"

"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
}

Loading

---

Generated by tbls