iteyesboard
Tables (9)
Untitled (member)
- Key (member_id) — varchar(20) — Primary key — NOT NULL
- Field (member_nickname) — varchar(20)
- Field2 (member_password) — varchar(100)
- Field (member_email) — varchar(20)
- Field (member_join_date) — timestamp
- Field (member_del_date) — timestamp
Untitled (food)
- Key (food_no) — int — Primary key — NOT NULL
- Key (food_write_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (food_title) — varchar(60)
- Field2 (food_content) — varchar(1000)
- Field3 (food_view_count) — int
- Field4 (food_write_date) — timestamp
- Field (food_modify_date) — timestamp
- Field (food_main_image) — varchar(100)
- Field (food_sub_image2) — varchar(100)
- Field (food_sub_image3) — varchar(100)
- Field (food_sub_image4) — varchar(100)
- Field2 (food_sub_image5) — varchar(100)
- Field (food_comment_count) — int
Untitled (food_comment)
- Key (food_cmt_no) — int — Primary key — NOT NULL
- Key (food_cmt_write_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Key (food_cmt_origin_no) — int — Foreign key → Untitled.Key — NOT NULL
- Field (food_cmt_group_no) — intv
- Field (food_cmt_parent_nickname) — varchar(20)
- Field (food_cmt_content) — varchar(1000)
- Field2 (food_cmt_write_date) — timestamp
- Field3 (food_cmt_modify_date) — timestamp
- Field4 (food_cmt_del_date) — timestamp
- Field6 (food_cmt_write_nickname) — varchar(20)
Untitled (music_board_table)
- Key (music_board_no) — int — Primary key — NOT NULL
- Key (music_board_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (music_board_title) — varchar(50)
- Field2 (music_board_content) — text
- Field3 (music_board_readView) — int
- Field4 (music_board_CreatedDate) — timestamp
- Field5 (music_board_EditDate) — timestamp
- Field (music_board_commentCnt) — int
Untitled (music_board_member_mapping)
- Key (music_board_id) — varchar(20) — Primary key — NOT NULL
- Key (member_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (music_comment_table)
- Key (music_cmt_no) — int — Primary key — NOT NULL
- Key (music_board_no) — int — Foreign key → Untitled.Key — NOT NULL
- Key (music_cmt_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (music_cmt_content) — text
- Field (music_cmt_CreatedDate) — timestamp
- Field3 (music_cmt_EditDate) — timestamp
- Field2 (music_cmt_DelDate) — timestamp
- Field4 (music_cmt_parent_id) — varchar(20)
- Field5 (music_cmt_depth) — varchar(20)
- Field (music_board_nickname) — varchar(20)
Untitled (SOCCER)
- Key (soccer_id) — int — Primary key — NOT NULL
- Key (member_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (soccer_title) — varchar(50)
- Field (soccer_content) — varchar(800)
- Field (soccer_date_created) — timestamp int
- Field (soccer_reply_count) — int
- Field2 (soccer_view_count) — int
- Field3 (soccer_image) — varchar(100)
- Field4 (soccer_like_count) — int
Untitled (soccer_comment)
- Key (soccer_comment_id) — int — Primary key — NOT NULL
- Key (soccer_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (member_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (member_nickname) — varchar(20)
- Field2 (comment_content) — varchar(500)
- Field3 (comment_date_created) — timestamp
- Field4 (comment_date_deleted) — timestamp
Untitled (soccer_like)
- Key (like_id) — int — Primary key — NOT NULL
- Key (soccer_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (member_id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (thumbs_up) — varchar(1)