board-project

Tables (5)

BBS_BOARD

  • B_ID — PRIMARY KEY — Primary key — NOT NULL
  • Key (B_WRITER) — NOT NULL — Foreign key → BBS_USER.Key — NOT NULL
  • Field (B_WRITE_DATE) — NOT NULL
  • Field2 (B_UPDATE_DATE) — NOT NULL
  • Field3 (B_SUBJECT) — NOT NULL
  • Field4 (B_CONTENT)
  • Field (B_VIEWS)
  • Field (B_RECOMMEND)
  • Field (B_REPLY_COUNT)

BBS_RECOMMEND

  • Key (R_ID) — PRIMARY KEY — Primary key — NOT NULL
  • Key (R_USERID) — NOT NULL — Foreign key → BBS_USER.Key — NOT NULL
  • B_ID (R_B_ID) — NOT NULL — Foreign key → BBS_BOARD.B_ID — NOT NULL
  • Field (R_DATE) — NOT NULL

BBS_USER

  • Key (USERID) — PRIMARY KEY — Primary key — NOT NULL
  • Field (UWERPW) — NOT NULL
  • Field (REG_DATE) — NOT NULL
  • Field (UPDATE_DATE)
  • Field (ENABLED)

Copy Of BBS_BOARD (BBS_COMMENT)

  • B_ID (C_ID) — PRIMARY KEY — Primary key — NOT NULL
  • B_ID (C_B_ID) — NOT NULL — Foreign key → BBS_BOARD.B_ID — NOT NULL
  • Field2 (C_P_ID)
  • Key (C_WRITER) — NOT NULL — Foreign key → BBS_USER.Key — NOT NULL
  • Field3 (C_WRITE_DATE) — NOT NULL
  • Field (C_COMMENT) — NOT NULL

Untitled (BBS_USER_AUTH)

  • Key (USERID) — PRIMARY KEY — Foreign key → BBS_USER.Key — NOT NULL
  • Field (AUTH) — NOT NULL