test
Tables (11)
food
- id — bigint — Primary key — NOT NULL
- food_type
food_preferences
- id — bigint — Primary key — NOT NULL
- food_id — bigint — Foreign key → food.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
inquiry
- id — bigint — Primary key — NOT NULL
- title — varchar(20)
- context — string
- img_url — string
- created_at — datetime(6)
- updated_at — datetime(6)
- answer_status — varchar(20)
- user_id — bigint — Foreign key → users.id — NOT NULL
inquiry_img
- id — bigint — Primary key — NOT NULL
- img_url — string
- id (id2) — bigint — Foreign key → inquiry.id — NOT NULL
inquiry_type (Untitled)
- id — bigint — Primary key — NOT NULL
- type — varchar(20)
- inquiry_id — bigint — Foreign key → inquiry.id — NOT NULL
mission
- owner_id — int — Primary key — NOT NULL — 사장구분코드
- store — varchar(20)
- date — date — 미션 수행 가능한 날짜
- cost — int — 얼마 이상 써야 미션 성공인지 나타내는 금액
- point — int — 미션 성공하면 몇 포인트 주는지
- point_rate — int — 포인트 적립 비율
mission_status
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- owner_id — int — Foreign key → mission.owner_id — NOT NULL
review
- id — bigint — Primary key — NOT NULL
- star_count — int
- context — string
- Field2
- user_id — bigint — Foreign key → users.id — NOT NULL
review_img
- Key — Primary key — NOT NULL
- id — bigint
- img_url — string
- review_id — bigint — Foreign key → review.id — NOT NULL
store_category
- id — bigint — Primary key — NOT NULL
- category (categry) — varchar(20)
- owner_id — int — Foreign key → mission.owner_id — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- gender — int — NOT NULL — 0:남자, 1:여자
- birth — int
- city — varchar(20) — 시
- district — varchar(20) — 구
- neighborhood — varchar(20) — 동
- status — varchar(20)
- inactive_date — datetime