board
Tables (4)
BOARD
- ID — BIGINT(25) — Primary key — NOT NULL
- NAME — VARCHAR(255)
- DESCRIPTION — VARCHAR(255)
MEMBER
- ID — BIGINT(20) — Primary key — NOT NULL
- USER_ID — VARCHAR(255)
- NAME — VARCHAR(255)
- ZIPCODE — VARCHAR(255)
- STREET — VARCHAR(255)
- DETAIL_ADDRESS — VARCHAR(255)
- CREATED_DATE — TIMESTAMP
- MODIFIED_DATE — TIMESTAMP
OPT_ITEM
- USE_INTT_ID — VARCHAR(20) — Primary key — NOT NULL
- KEY — VARCHAR(50)
- PRT_ORD — NUMERIC(2)
- RQRD_YN — VARCHAR(1)
POST
- ID — BIGINT(25) — Primary key — NOT NULL
- MEMBER_ID — BIGINT(20) — Foreign key → MEMBER.ID — NOT NULL
- BOARD_ID — BIGINT(25) — Foreign key → BOARD.ID — NOT NULL
- TITLE — VARCHAR(255)
- CONTENT — TEXT
- VIEW_COUNT — BIGINT(20)
- CREATED_DATE — TIMESTAMP
- MODIFIED_DATE — TIMESTAMP