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