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