공예쁨
테이블 (25)
Buyer (buyers)
- buyer_id (Key) — bigint — 기본 키 — NOT NULL
- user_id (FK) — bigint — 외래 키 → User.user_id
CategoryMapping (category_mappings)
- category_mapping_id (id) — int — 기본 키 — NOT NULL
- item_id (id2) — int — 외래 키 → Item.item_id — NOT NULL
- category_id — int — 외래 키 → category.category_id — NOT NULL
ChatRoom (chat_rooms)
- chatroom_id (Key) — bigint — 기본 키 — NOT NULL
- buyer_id (FK) — bigint — 외래 키 → Buyer.buyer_id — NOT NULL
- seller_id (FK2) — bigint — 외래 키 → Seller.seller_id — NOT NULL
Color (colors)
- color_id (id) — bigint — 기본 키 — NOT NULL
- color (Field2) — varchar
ColorMapping (color_mappings)
- item_tag_mapping_id (id) — bigint — 기본 키 — NOT NULL
- item_id (id2) — int — 외래 키 → Item.item_id — NOT NULL
- color_id — int — 외래 키 → Color.color_id — NOT NULL
Delivery Company (delivery_company)
- delivery_company_id — bigint — 기본 키 — NOT NULL
- name
- code
Delivery Info (delivery_info)
- delivery_info_id — bigint — 기본 키 — NOT NULL
- invoice_number
- order_id — bigint — 외래 키 → Order.order_id — NOT NULL
- delivery_company_id — bigint — 외래 키 → Delivery Company.delivery_company_id — NOT NULL
Device (devices)
- device_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → User.user_id
- fcm_token (Field) — varchar
Exhibition (exhibitions)
- exhibition_id (id) — int — 기본 키 — NOT NULL
- seller_id (Key) — int — 외래 키 → Seller.seller_id — NOT NULL
- start_date (date1) — datetime
- end_date (date2) — datetime
- title (Field) — varchar
- biography (Field2) — varchar
- background_color (Field3) — varchar
- font_family (Field4) — varchar
- cover_image (Field5) — varchar
- artist_image (Field6) — varchar
- artist_name (Field7) — varchar
- is_template (Field8) — boolean
ExhibitionImage (exhibition_images)
- exhibition_image_id (Key) — int — 기본 키 — NOT NULL
- exhibition_item_id (Key2) — int — 외래 키 → ExhibitionItem.exhibition_item_id — NOT NULL
- image (Field2) — varchar
ExhibitionItem (exhibition_items)
- exhibition_item_id (Key) — int — 기본 키 — NOT NULL
- exhibition_id (id) — int — 외래 키 → Exhibition.exhibition_id — NOT NULL
- item_id (id2) — int — 외래 키 → Item.item_id — NOT NULL
- title (Field) — varchar
- description (Field2) — varchar
- template (Field3) — int
- is_sale (Field4) — boolean
- background_color (Field5) — varchar
- font_family (Field6) — varchar
- position (Field7) — int
- is_custom (Field8) — boolean
ExhibitionSound (exhibition_sounds)
- exhibition_sound_id (Key) — int — 기본 키 — NOT NULL
- exhibition_item_id (Key2) — int — 외래 키 → ExhibitionItem.exhibition_item_id — NOT NULL
- sound (Field) — varchar
Item (items)
- item_id (id) — bigint — 기본 키 — NOT NULL
- seller_id — bigint — 외래 키 → Seller.seller_id — NOT NULL
- price — int
- max_amount — int
- current_amount — int
- description — varchar
- title — varchar
- shorts — varchar
- width (Field) — float
- depth (Field2) — float
- height (Field3) — float
- display_dt — datetime
- start_date (Field4) — datetime
- end_date (Field5) — datetime
ItemImage (item_images)
- item_image_id (id) — bigint — 기본 키 — NOT NULL
- is_thumbnail — boolean
- item_id (id2) — bigint — 외래 키 → Item.item_id — NOT NULL
- image — varchar
Like (likes)
- like_id — int — 기본 키 — NOT NULL
- item_id (id2) — int — 외래 키 → Item.item_id — NOT NULL
- buyer_id (Key) — int — 외래 키 → Buyer.buyer_id — NOT NULL
Message (messages)
- message_id (Key) — bigint — 기본 키 — NOT NULL
- chatroom_id (FK) — bigint — 외래 키 → ChatRoom.chatroom_id — NOT NULL
- id (Key2) — bigint — 외래 키 → User.user_id
- write_date (Field) — datetime
- is_read (Field2) — boolean
- text (Field3) — string
- image (Field4) — varchar(250)
Order (Untitled)
- order_id — bigint — 기본 키 — NOT NULL
- buyer_id — bigint — 외래 키 → Buyer.buyer_id — NOT NULL
- item_id — bigint — 외래 키 → Item.item_id — NOT NULL
- order_status_id — bigint — 외래 키 → Order Status.order_status_id — NOT NULL
- price — int
- name — varchar
- address — varchar
- phone_number — varchar
- zipcode — int
Order History (order_history)
- order_history_id — 기본 키 — NOT NULL
- order_status_id — bigint — 외래 키 → Order Status.order_status_id — NOT NULL
- order_id — bigint — 외래 키 → Order.order_id — NOT NULL
Order Status (order_status)
- order_status_id — bigint — 기본 키 — NOT NULL
- status (주문완료/배송중/배송완료/주문취소) — varchar
RecentlyViewedItem (RecentlyViewedItems)
- user_id — int — 외래 키 → User.user_id
- item_id — int — 외래 키 → Item.item_id — NOT NULL
- viewed_date (Field) — datetime
Review (reviews)
- review_id — int — 기본 키 — NOT NULL
- rating — int
- comment — string
- order_id — int — 외래 키 → Order.order_id — NOT NULL
Seller (sellers)
- seller_id (Key) — bigint — 기본 키 — NOT NULL
- user_id (FK) — bigint — 외래 키 → User.user_id
- email (Field) — varchar(50)
- temperature (Field2) — decimal
- description (Field3) — varchar(80)
User (users)
- user_id (Key) — bigint — 기본 키
- nickname (Field) — varchar(10) — NOT NULL
- profile_image (Field2) — varchar(250)
- inactive_datetime — datetime — NOT NULL
- is_agree_privacy (Field4) — boolean
- is_agree_ads (Field5) — boolean
- joined_date — datetime
- is_seller (Field3) — boolean
- is_staff (Field6) — boolean
- created_date (Field7) — datetime
- created_no (Field8) — bigint
- modified_date (Field9) — datetime
- modified_no (Field10) — datetime
- is_agree_terms (Field11) — boolean
UserOauthInfo (users_oauth)
- user_oauth_info_id — bigint — 기본 키 — NOT NULL
- user_Id (user_id) — int — 외래 키 → User.user_id
- provider (Field3) — varchar
- provider_id (Field4) — varchar
- access_token (Field)
- refresh_token (Field2)
- expired_date (Field5)
category (categories)
- category_id — int — 기본 키 — NOT NULL
- category (Field) — varchar