공예쁨

테이블 (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