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)