BBS Project

Tables (7)

authorities

  • id — bigint — Primary key — NOT NULL
  • authority — varchar(50)
  • username — varchar(50) — Foreign key → tbl_users.id — NOT NULL

tbl_b_recommend

  • b_r_id — BIGINT — Primary key
  • b_r_username — VARCHAR(50)
  • b_r_board_id — BIGINT — Foreign key → tbl_bbs.B_ID

tbl_bbs

  • B_ID — BIGINT — Primary key
  • B_P_ID — BIGINT
  • B_DATE — VARCHAR(10) — NOT NULL
  • B_TIME — VARCHAR(10) — NOT NULL
  • B_SUBJECT — VARCHAR(125) — NOT NULL
  • B_TEXT — VARCHAR(1000) — NOT NULL
  • B_COUNT — BIGINT
  • B_WRITER — VARCHAR(50) — Foreign key → tbl_users.id — NOT NULL

tbl_c_recommend

  • c_r_id — BIGINT — Primary key
  • c_r_username — VARCHAR(50)
  • c_r_board_id — BIGINT — Foreign key → tbl_comment.c_id

tbl_comment

  • c_id — BIGINT — Primary key
  • c_p_id — BIGINT
  • c_date_time — VARCHAR(30)
  • c_writer — VARCHAR(30)
  • c_subject — VARCHAR(125) — NOT NULL
  • c_b_id — BIGINT — Foreign key → tbl_bbs.B_ID

tbl_images

  • img_file_seq — bigint — Primary key
  • img_file_origin_name — VARCHAR(255)
  • img_file_upload_name — VARCHAR(255)
  • img_file_b_code — BIGINT — Foreign key → tbl_bbs.B_ID

tbl_users

  • id — bigint — Primary key — NOT NULL
  • user_id — varchar(50)
  • user_pass — varchar(125)
  • enabled — tinyint(1)
  • email — varchar(50)
  • phone — varchar(20)
  • address — varchar(125)