BSeven_FreeBoard

Tables (5)

Untitled (M_Member)

  • Key (member_no) — number — Primary key — NOT NULL
  • Field (member_id) — varchar2(20)
  • Field (member_pw) — varchar2(100)
  • Field (member_nickname) — varchar2(20)
  • Field (member_birth) — date
  • Field (member_phone) — varchar2(30)
  • Field (member_email) — varchar2(100)
  • Field (member_joindate) — date

Untitled (ajs_board)

  • Key (board_no) — number — Primary key — NOT NULL
  • Key (member_no) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (board_title) — varchar2(100)
  • Field (board_content) — varchar2(400)
  • Field (board_createdate) — date
  • Field (board_viewcount) — number
  • Field (board_status) — varchar2(1)

Untitled (ajs_reply)

  • Key (reply_no) — number — Primary key — NOT NULL
  • Key (board_no) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (reply_content) — varchar2(100)
  • Field (reply_createdate) — date
  • Field (reply_status) — varchar2(1)

Untitled (ajs_images)

  • Key (image_no) — number — Primary key — NOT NULL
  • Key (board_no) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — varchar2(300)
  • Field (image_filename) — varchar2(300)
  • Field (image_originalfilename) — varchar2(300)

Untitled (ajs_thumbs)

  • Key (thumb_no) — number — Primary key — NOT NULL
  • Key (board_no) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — number — Foreign key → Untitled.Key — NOT NULL