UMC6th

Tables (9)

ADDRESS

  • id (Field) — BIGINT — Primary key — NOT NULL
  • user_id (Field3) — BIGINT — Foreign key → USER.id — NOT NULL
  • address (Field2) — VARCHAR(30) — NOT NULL
  • address_detail (Field4) — VARCHAR(100) — NOT NULL

LikeFoodCat (Untitled7)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Field) — BIGINT — Foreign key → USER.id — NOT NULL
  • restarunt_id (Key2) — BIGINT — Foreign key → RESTARUNT_CATEGORY.id — NOT NULL

MISSION (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Field6) — BIGINT — Foreign key → USER.id — NOT NULL
  • restarunt_id (Key2) — BIGINT — Foreign key → RESTARUNT.id — NOT NULL
  • region_name (Field5) — VARCHAR(10) — Foreign key → REGION.region_name — NOT NULL
  • price (Field) — INT — NOT NULL
  • saved_point (Field2) — INT — NOT NULL
  • dead_line (Field3) — DATE — NOT NULL
  • created_at (Field7) — DATE — NOT NULL
  • is_completed (Field4) — BOOLEAN — NOT NULL

REGION (Untitled5)

  • region_name (Field) — VARCHAR(10) — Primary key — NOT NULL
  • completed_mission_cnt (Field2) — INT — NOT NULL
  • is_finish (Field3) — BOOLEAN — NOT NULL

RESTARUNT (Untitled4)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • category_id (Key2) — BIGINT — Foreign key → RESTARUNT_CATEGORY.id — NOT NULL
  • name (Field) — VARCHAR(20) — NOT NULL
  • rating (Field3) — FLOAT — NOT NULL
  • location (Field4) — VARCHAR(40) — NOT NULL
  • office_hours (Field2) — TIME — NOT NULL

RESTARUNT_CATEGORY (Untitled6)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(15) — NOT NULL

REVIEW (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Field2) — BIGINT — Foreign key → USER.id — NOT NULL
  • restarunt_id (Key2) — BIGINT — Foreign key → RESTARUNT.id — NOT NULL
  • review (Field) — TEXT — NOT NULL
  • rating (Field3) — FLOAT — NOT NULL

REVIEW_PHOTO (CopyOfUntitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • review_id (Key2) — BIGINT — Foreign key → REVIEW.id — NOT NULL
  • review_img_url (Field2) — VARCHAR

USER (Untitled)

  • id (Field) — BIGINT — Primary key — NOT NULL
  • name (Field2) — VARCHAR(10) — NOT NULL
  • nickname (Field5) — VARCHAR(10) — NOT NULL
  • gender (Field3) — VARCHAR(10) — NOT NULL
  • birth (Field4) — DATE — NOT NULL
  • point (Field6) — INT — NOT NULL