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)