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)