팜컴어스

테이블 (11)

cart_list

  • cart_id — bigint — 기본 키 — NOT NULL
  • member_id (member_id2) — BigInt — 외래 키 → member.member_id — NOT NULL
  • member_id — bigint — NOT NULL
  • item_id — bigint — NOT NULL
  • cart_item_count — int

category

  • category_id — bigint — 기본 키 — NOT NULL
  • category_name — varchar(25) — NOT NULL

delivery_info

  • delivery_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • delivery_addr — VARCHAR(255) — NOT NULL
  • delivery_name — VARCHAR(10) — NOT NULL
  • delivery_phone_number — VARCHAR(15) — NOT NULL
  • order_id — bigint — 외래 키 → order_info.order_id — NOT NULL
  • member_id (member_id2) — BigInt — 외래 키 → order_info.member_id — NOT NULL
  • oitem_id — bigint — 외래 키 → order_info.oitem_id — NOT NULL

item

  • item_id — BIGINT — 기본 키 — NOT NULL
  • item_name — VARCHAR(25) — NOT NULL
  • item_description — VARCHAR(255) — NOT NULL
  • item_img — VARCHAR(255) — NOT NULL
  • item_price — INT — NOT NULL
  • item_discount — INT
  • category_id — BIGINT — 외래 키 → category.category_id — NOT NULL
  • store_id — BIGINT — 외래 키 → store.store_id — NOT NULL
  • item_created_at — DATETIME — NOT NULL
  • slike_id — bigint — 외래 키 → store.slike_id — NOT NULL
  • member_id (member_id2) — BigInt — 외래 키 → store.member_id — NOT NULL

live

  • live_id — bigint — 기본 키 — NOT NULL
  • store_id (store_id2) — BIGINT — 외래 키 → store.store_id — NOT NULL
  • slike_id — bigint — 외래 키 → store.slike_id — NOT NULL
  • member_id (member_id2) — BigInt — 외래 키 → store.member_id — NOT NULL
  • item_id — bigint — NOT NULL
  • live_start — datetime — NOT NULL
  • live_end — datetime — NOT NULL
  • live_discount — int
  • store_id — bigint — NOT NULL

member

  • member_id — BigInt — 기본 키 — NOT NULL
  • nickname — varchar(10) — NOT NULL
  • email — varchar(30) — NOT NULL
  • profile_img — varchar(255)
  • exist_store — boolean — NOT NULL
  • street_addr — varchar(50) — NOT NULL
  • zipcode — varchar(10) — NOT NULL
  • detailed_addr — varchar(50) — NOT NULL
  • access_token — varchar(255)
  • phone_number — varchar(15) — NOT NULL

order_info

  • order_id — bigint — 기본 키 — NOT NULL
  • member_id (member_id2) — BigInt — 외래 키 → member.member_id — NOT NULL
  • oitem_id — bigint — 외래 키 → order_item.oitem_id — NOT NULL
  • member_id — bigint — NOT NULL
  • delivery_id — bigint — NOT NULL
  • order_created_at — datetime — NOT NULL

order_item

  • oitem_id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — NOT NULL
  • item_id — bigint — NOT NULL
  • store_id — bigint — NOT NULL
  • oitem_count — int
  • oitem_status — varchar(10)
  • oitem_created_at — datetime — NOT NULL

reserved_live

  • reserved_live_id — bigint — 기본 키 — NOT NULL
  • live_id (live_id2) — bigint — 외래 키 → live.live_id — NOT NULL
  • store_id (store_id2) — BIGINT — 외래 키 → live.store_id — NOT NULL
  • slike_id — bigint — 외래 키 → live.slike_id — NOT NULL
  • member_id (member_id22) — BigInt — 외래 키 → live.member_id — NOT NULL
  • member_id — bigint — NOT NULL
  • live_id — bigint — NOT NULL
  • reserved_live_start — datetime — NOT NULL
  • member_id (member_id2) — BigInt — 외래 키 → member.member_id — NOT NULL

store

  • store_id — BIGINT — 기본 키 — NOT NULL
  • slike_id — bigint — 외래 키 → store_like.slike_id — NOT NULL
  • member_id (member_id2) — BigInt — 외래 키 → store_like.member_id — NOT NULL
  • store_name — VARCHAR(15) — NOT NULL
  • store_description — VARCHAR(255) — NOT NULL
  • store_img — VARCHAR(255) — NOT NULL
  • store_street_addr — VARCHAR(50) — NOT NULL
  • store_detail_addr — VARCHAR(50) — NOT NULL
  • store_zipcode — VARCHAR(10) — NOT NULL
  • store_phone_number — VARCHAR(15) — NOT NULL
  • sotre_created_at — DATETIME — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL

store_like

  • slike_id — bigint — 기본 키 — NOT NULL
  • member_id (member_id2) — BigInt — 외래 키 → member.member_id — NOT NULL
  • member_id — bigint — NOT NULL
  • store_id — bigint — NOT NULL