ERD_DB_1-3
Tables (6)
CATEGORY_2 (주제( 소 ))
- cat2_id (Key) — SMALLINT — Primary key — NOT NULL
- cat1_id (Key2) — SMALLINT — Foreign key → CATEGROY_1.cat1_id — NOT NULL
- name (Field) — VARCHAR(16)
CATEGROY_1 (주제( 대 ))
- cat1_id (Key) — SMALLINT — Primary key — NOT NULL
- name (Field) — VARCHAR(16)
COMMENT (뉴스 댓글)
- id (Key) — INT — Primary key — NOT NULL
- news_id (Key2) — MEDIUMINT — Foreign key → NEWS.id — NOT NULL
- user_id (Key3) — MEDIUMINT — Foreign key → USER.id — NOT NULL
- comment (Field1) — TEXT
- date_upload (Field2) — DATETIME
NEWS (뉴스 정보)
- id (Key) — MEDIUMINT — Primary key — NOT NULL
- platform_id (Key2) — SMALLINT — Foreign key → PLATFORM.id — NOT NULL
- cat1_id (Key4) — SMALLINT — Foreign key → CATEGROY_1.cat1_id — NOT NULL
- cat2_id (Key3) — SMALLINT — Foreign key → CATEGORY_2.cat2_id — NOT NULL
- title (Field1) — VARCHAR(256)
- press (Field2) — VARCHAR(16)
- writer (Field3) — VARCHAR(16)
- date_upload (Field4) — DATETIME
- date_fix (Field5) — DATETIME
- content (Field6) — TEXT
- num_comm (Field7) — INT(128)
- sticker (Field8) — JSON
- url (Field9) — VARCHAR(256)
PLATFORM (플랫폼)
- id (Key) — SMALLINT — Primary key — NOT NULL
- name (Field) — VARCHAR(8)
USER (사용자 정보)
- id (Key) — MEIDUMINT — Primary key — NOT NULL
- platform_id (Key2) — SMALLINT — Foreign key → PLATFORM.id — NOT NULL
- user_id (Field) — VARCHAT(16)