self

Tables (15)

announcement

  • id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — VARCHAR(255)
  • contents (Field2) — varchar(1000)

cause_detail

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL — 회원테이블의 기본키
  • resigned_cause — varchar(255)

ingredient

  • id (Key) — bigint — Primary key — NOT NULL
  • ingredient_name (Field) — varchar(20)

order_possible_day

  • id (Key) — bigtint — Primary key — NOT NULL
  • product_id (id) — bigint — Foreign key → product.id — NOT NULL
  • week_of_day (Field) — varchar(5)

product

  • id — bigint — Primary key — NOT NULL
  • store_id (id2) — bigint — Foreign key → store.id — NOT NULL
  • name — varchar(255) — NOT NULL
  • price — int — NOT NULL
  • created — datetime — NOT NULL
  • modified — datetime
  • category (Field) — varchar(20)
  • product_profile (Field2) — varchar(255)
  • product_url (Field3) — varchar(255)

product_img (CopyOfsearch)

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • product_id (id) — bigint — Foreign key → product.id — NOT NULL
  • img_url (Field) — VARCHAR(255)

product_ingredient

  • id (Key) — bigint — Primary key — NOT NULL
  • product_id (Key2) — bigint — Foreign key → ingredient.id — NOT NULL
  • ingredient_id (id) — bigint — Foreign key → product.id — NOT NULL

search

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • Field — VARCHAR(255)

store

  • id — bigint — Primary key — NOT NULL
  • store_name (Field) — varchar(255)
  • store_introduction (Field2) — varchar(500)
  • store_profile (Field3) — varchar(255)

terms

  • id — bigint — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL
  • contents — varchar(255) — NOT NULL — url로 할 것

user

  • id — bigint — Primary key — NOT NULL — 회원테이블의 기본키
  • name — varchar(255) — NOT NULL
  • login_id — varchar(255) — NOT NULL — unique
  • provider — varchar(15)
  • profile_img — varchar(100)
  • nickname — varchar(10)
  • sex — varchar(1) — NOT NULL — M or W
  • email — varchar(255) — NOT NULL
  • phone_number — varchar(255)
  • address — varchar(255)
  • created_at — datetime — NOT NULL
  • modified_at — datetime
  • resigned_at — datetime

user_terms

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL — 회원테이블의 기본키
  • terms_id — bigint — Foreign key → terms.id — NOT NULL
  • agreed_at — datetime

wish_list_folder

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (id) — bigint — Foreign key → user.id — NOT NULL — 회원테이블의 기본키
  • user_id (id2) — bigint — Foreign key → wish_product_list.user_id — NOT NULL — 회원테이블의 기본키

wish_market_list

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (id) — bigint — Foreign key → user.id — NOT NULL — 회원테이블의 기본키
  • product_id (id2) — bigint — Foreign key → product.id — NOT NULL

wish_product_list

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (id) — bigint — Foreign key → user.id — NOT NULL — 회원테이블의 기본키
  • product_id (id2) — bigint — Foreign key → product.id — NOT NULL