UMC_week04_mission

Tables (8)

Untitled (mymission)

  • Key (PK) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field6 — varchar(20)
  • Field — text
  • Field5 — bigint
  • Field2 — bigint
  • Field3 — varchar(10)
  • Field4 — varchar(15)
  • Key (FK1) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (FK2) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (region_mission)

  • Key (PK) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field — varchar(10)
  • Field2 — int
  • Field3 — varchar(15)

Untitled (agreement)

  • Key (PK) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field — int
  • Field2 — int
  • Field3 — int
  • Field4 — int
  • Field5 — int

Untitled (member)

  • Key (PK) — bigint — Primary key — NOT NULL
  • Field — varchar(10)
  • Field2 — bigint
  • Field3 — varchar(10)
  • Field4 — text
  • Field5 — text
  • Field6 — datetime(6)
  • Field7 — datetime(6)
  • Field8 — datetime

Untitled (food)

  • Key (PK) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field — int
  • Field2 — int
  • Field3 — int
  • Field4 — int
  • Field5 — int
  • Field6 — int
  • Field7 — int
  • Field8 — int
  • Field9 — int
  • Field10 — int
  • Field11 — int
  • Field12 — int

Untitled (store)

  • Key (PK) — bigint — Primary key — NOT NULL
  • Field — varchar(20)
  • Field2 — text
  • Field3 — bigint
  • Field4 — float
  • Field5 — varchar(10)

Untitled (review)

  • Key (PK) — bigint — Primary key — NOT NULL
  • Key (FK1) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (FK2) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field — datetime(6)
  • Field2 — datetime(6)

Untitled (scope)

  • Key (PK) — bigint — Primary key — NOT NULL
  • Key (FK1) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (FK2) — bigint — Foreign key → Untitled.Key — NOT NULL