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