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)