kuckerton

Tables (6)

certification (Untitled2)

  • id (Key) — long — Primary key — NOT NULL
  • img_url (Field) — varchar(200)
  • title (Field3) — varchar(100)
  • review (Field2) — text
  • date (Field4) — date
  • is_cleared (Field5) — bool
  • id (Key2) — long — Foreign key → member.id — NOT NULL

config (Untitled6)

  • id (Key) — long — Primary key — NOT NULL
  • category (Field) — varchar(50)
  • want (Field2) — bool
  • id (Key2) — long — Foreign key → member.id — NOT NULL

coupon (Untitled3)

  • id (Key) — long — Primary key — NOT NULL
  • content (Field) — text
  • id (Key2) — long — Foreign key → store.id — NOT NULL
  • id (Key3) — long — Foreign key → member.id — NOT NULL

member (Untitled)

  • id (Key) — long — Primary key — NOT NULL
  • nickname (Field) — varchar(50)
  • level (Field2) — int
  • start_time (Field3) — TimeStamp
  • end_time (Field4) — Timestamp
  • authId (Field5) — long

store (Untitled4)

  • id (Key) — long — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • category (Field2) — varchar(100)
  • latitude (Field3) — double
  • longitude (Field4) — double
  • is_opened (Field5) — bool
  • end_time (Field6) — time
  • id (Key2) — long — Foreign key → task.id — NOT NULL

task (Untitled5)

  • id (Key) — long — Primary key — NOT NULL
  • content (Field) — text
  • category (Field2) — varchar(50)
  • timing (Field3) — Time
  • title (Field4) — varchar(100)