트립온 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