UMC_chapter4
Tables (9)
food_type (Untitled)
- Key — Primary key — NOT NULL
- name — varchar(40) — NOT NULL
member
- Key — Primary key — NOT NULL
- region_address — bigint — Foreign key → my_region.Key — NOT NULL
- spec_address — archer(40)
- name — varchar(40) — NOT NULL
- gender — bigint — NOT NULL
- birthday — bigint
- email — varchar(40)
- point — bigint — NOT NULL
- mission_count — bigint
mission (Untitled2)
- id — bigint — Primary key — NOT NULL
- shop_id — bigint — Foreign key → shop.id — NOT NULL
- name — varchar(100)
- deadline (Field) — bigint
- how_success — varcher(100) — NOT NULL
- point — bigint — NOT NULL
- reward (reawrd) — archer(100)
my_like (Untitled5)
- like_id — bigint — Foreign key → food_type.Key — NOT NULL
- Key — Foreign key → member.Key — NOT NULL
my_region (Untitled7)
- Key (Key2) — Foreign key → region.Key — NOT NULL
mymission (domission)
- id (Key) — bigint — Primary key — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- Key (Key2) — Foreign key → member.Key — NOT NULL
- doing_done — isActive — NOT NULL
region (Untitled6)
- Key — Primary key — NOT NULL
- name — NOT NULL
review (Untitled3)
- Key2 — Primary key — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- shop_id — bigint — Foreign key → shop.id — NOT NULL
- member_id — Foreign key → member.Key — NOT NULL
- body — varchar(100) — NOT NULL
- reviewstar — bigint — NOT NULL
- date — bigint — NOT NULL
shop (Untitled4)
- id — bigint — Primary key — NOT NULL
- foodtype_id (Key) — Foreign key → food_type.Key — NOT NULL
- name — varchar(40) — NOT NULL
- introduce — varchar(100)