UMC_W1_mission
Tables (8)
Member (Untitled)
- member_id (id) — bigint — Primary key — NOT NULL
- gender — bool
- birthday (birth) — datetime
- address — varchar(20)
- member_pw — varchar(20)
- nickname — varchar(10)
- email — varchar(20)
- mypoint — bigint
Mission (Untitled2)
- mission_id — bigint — Primary key — NOT NULL
- reward — int
- deadline — datetime
- upload_date — datetime
Mission_member (Untitled3)
- id — bigint — Primary key — NOT NULL
- member_id (id2) — dtype — Foreign key → Member.member_id — NOT NULL
- mission_id — bigint — Foreign key → Mission.mission_id — NOT NULL
- status — varchar(10)
food_category (Untitled7)
- id — bigint — Primary key — NOT NULL
- category_name — varchat(20)
member_like (Untitled6)
- id — bigint — Primary key — NOT NULL
- member_id (id2) — bigint — Foreign key → Member.member_id — NOT NULL
- id (id3) — bigint — Foreign key → food_category.id — NOT NULL
review (Untitled4)
- id — bigint — Primary key — NOT NULL
- id (id2) — bigint — Foreign key → store.id — NOT NULL
- member_id (id3) — bigint — Foreign key → Member.member_id — NOT NULL
- star — int
- create_date — datetime
- Field
review_image (Untitled8)
- image_id (id) — bigint — Primary key — NOT NULL
- id (id2) — bigint — Foreign key → review.id — NOT NULL
- id (id22) — bigint — Foreign key → review.id — NOT NULL
- member_id (id3) — bigint — Foreign key → review.member_id — NOT NULL
- url — string
- upload_date — datetime
store (Untitled5)
- id — bigint — Primary key — NOT NULL
- store_name — varchar(20)
- locate — varchar(50)
- open_state — bool