ShareCloset

Tables (8)

Board

  • board_id — Long — Primary key — NOT NULL
  • member_id — Long — Foreign key → Member.member_id — NOT NULL — Auto_Increment
  • title — String — NOT NULL
  • content — String — NOT NULL

BoardImg

  • board_img_id — Long — Primary key — NOT NULL
  • board_id — Long — Foreign key → Board.board_id — NOT NULL
  • file_name — String — NOT NULL
  • ori_file_name — String — NOT NULL
  • file_url — String — NOT NULL

Deal

  • deal_id — Long — Primary key — NOT NULL
  • chatroom_id — Long — Foreign key → Untitled.chatroom_id — NOT NULL
  • money — String — NOT NULL
  • deal_date — LocalDateTime — NOT NULL
  • status — Enum — NOT NULL — 거래중/입금완료/거래완료 등

Dress

  • dress_id — Long — Primary key — NOT NULL
  • member_id — Long — Foreign key → Member.member_id — NOT NULL — Auto_Increment
  • dress_type — String — NOT NULL — ML or Select
  • file_name — String — NOT NULL
  • ori_file_name — String — NOT NULL
  • file_url — String — NOT NULL
  • dress_title — String

Member

  • member_id — Long — Primary key — NOT NULL — Auto_Increment
  • name — String — NOT NULL
  • sex — String — NOT NULL
  • age — int — NOT NULL
  • email — String — NOT NULL
  • password — String — NOT NULL
  • nickname — String — NOT NULL
  • address — String — NOT NULL
  • phone_number — String — NOT NULL
  • role — String — NOT NULL — 권한: user/admin/
  • member_lv — int — NOT NULL

TimeReg

  • create_time — LocalDateTime — NOT NULL
  • update_time — LocalDateTime
  • delete_time — LocalDateTime
  • create_by — String — NOT NULL
  • update_by — String
  • delete_by — String

Untitled (ChatRoom)

  • chatroom_id — Long — Primary key — NOT NULL
  • member_id (member_id_buyer) — Long — Foreign key → Member.member_id — NOT NULL — Auto_Increment
  • dress_id — Long — Foreign key → Dress.dress_id — NOT NULL
  • member_id (member_id_seller) — Long — Foreign key → Dress.member_id — NOT NULL — Auto_Increment
  • dress_title — String — NOT NULL
  • create_date — LocalDateTime — NOT NULL
  • seller_nick — String — NOT NULL
  • buyer_nick — String — NOT NULL
  • Field

Weather

  • weather_id — Long — Primary key — NOT NULL
  • date — Date — NOT NULL
  • tempe — Long — NOT NULL — 기온
  • type — Enum — 비/눈/맑음/폭염 등
  • region — String — NOT NULL