yf
Tables (11)
comment
- id — bigint — Primary key — NOT NULL
- review_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- content — text
- created_at — datetime
- updated_atd — datetime
food_category
- id — bigint — Primary key — NOT NULL
- name — varchar(15) — Enum 관리 방안 존재
- created_at — datetime(6)
- updated_at — datetime(6)
member
- id — bigint — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- gender — varchar(10) — NOT NULL
- age — int — NOT NULL
- birth — timestamp
- address — varchar(40) — NOT NULL
- spec_address — varchar(40) — NOT NULL
- status — varchar(15) — NOT NULL
- inactive_date — datetime — NOT NULL
- social_type — varchar(10) — NOT NULL
- email — varchar(50)
- point — int
- created_at — datetime(6)
- updated_at — datetime(6)
member_agreement
- id — bigint — Primary key — NOT NULL
- member_id — bigint — NOT NULL
- terms_id — bigint — NOT NULL
- agreed_at — datetime
member_mission
- id — bigint — Primary key — NOT NULL
- member_id — bigint — NOT NULL
- mission_id — bigint — NOT NULL
- status — Enum — Complete, Challenging, Cancel
- created_at — datetime(6)
- updated_at — datetime(6)
member_prefer
- id — bigint — Primary key — NOT NULL
- member_id — bigint — NOT NULL
- category_id — bigint — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
mission
- id — bigint — Primary key — NOT NULL
- store_id — bigint — NOT NULL
- reward — int
- deadline — datetime
- mission_spec — text
- created_at — datetime(6)
- updated_at — datetime(6)
review
- id — bigint — Primary key — NOT NULL
- member_id — bigint — NOT NULL
- store_id — bigint — NOT NULL
- body — text
- score — float
- created_at — datetime
- updated_at — datetime
review_image
- id — bigint — Primary key — NOT NULL
- review_id — bigint — NOT NULL
- imgae_url — text
- created_at — datetime(6)
- updated_at — datetime(6)
store
- id — bigint — Primary key — NOT NULL
- name — varchar(50)
- address — varchar(50)
- category — varchar(20) — Enum 방안도 존재
- score — float
- is_open — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
terms
- id — bigint — Primary key — NOT NULL
- title — varchar(20)
- content — text
- optional — boolean
- created_at — datetime(6)
- updated_at — datetime(6)