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