트립온 ERD

테이블 (3)

ACTIVITY (Untitled2)

  • ACT_NUM (Key) — INT — 기본 키 — NOT NULL
  • CATEGORY_NAME (Key2) — VARCHAR(20) — 외래 키 → CATEGORY.CATEGORY_NAME — NOT NULL
  • ACT_MAINTITLE (Field) — VARCHAR(100)
  • ACT_SUBTITLE (Field2) — VARCHAR(50)
  • ACT_WRITER (Field3) — VARCHAR(20)
  • ACT_REGDATE (Field4) — DATE
  • ACT_OPTNAME1 (Field5) — VARCHAR(60)
  • ACT_OPTNAME2 (Field6) — VARCHAR(60)
  • ACT_OPTNAME3 (Field7) — VARCHAR(60)
  • ACT_OPTNAME4 (Field8) — VARCHAR(60)
  • ACT_OPTPRICE1 (Field9) — INT
  • ACT_OPTPRICE2 (Field10) — INT
  • ACT_OPTPRICE3 (Field11) — INT
  • ACT_OPTPRICE4 (Field12) — INT
  • ACT_CONTENT (Field13) — VARCHAR(6000)
  • ACT_ANNOUNCEMENT (Field14) — VARCHAR(4000)
  • CATEGORYCHECK (Field15) — VARCHAR(20)
  • ACT_MAINPICKTURENAME (Field16) — VARCHAR(50)
  • ACT_INFORIMGNAME (Field17) — VARCHAR(50)
  • ACT_ADDRESS (Field18) — VARCHAR(1000)
  • ACT_THUMBINGNAME (Field19) — VARCHAR(50)
  • ACT_FAQ (Field20) — VARCHAR(6000)

CATEGORY (Untitled)

  • CATEGORY_NAME (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • CATEGORY_IMGNAME (Field) — VARCHAR(50)

REVIEW (Untitled3)

  • REVIEW_NUM (Key) — INT — 기본 키 — NOT NULL
  • ACT_NUM (Key2) — INT — 외래 키 → ACTIVITY.ACT_NUM — NOT NULL
  • REVIEW_CONTENT (Field) — VARCHAR(500)
  • REVIEW_WRITER (Field2) — VARCHAR(50)
  • REVIEW_DATETIME (Field3) — DATE