UMC_chapter4 - 2023-10-12 03:50:46
Tables (7)
member
- id — bigint — Primary key — NOT NULL
- name — varchar(40) — NOT NULL
- Field
- point — bigint — NOT NULL
- mission_count — bigint
mission (Untitled2)
- id — bigint — Primary key — NOT NULL
- shop_id — bigint — Foreign key — NOT NULL
- name — varchar(100)
my_like (Untitled5)
- like_id — bigint — Foreign key — NOT NULL
- member_id — bigint — Foreign key — NOT NULL
mymission (domission)
- id (Key) — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key — NOT NULL
- mission_id — bigint — Foreign key — NOT NULL
- doing_done — isActive — NOT NULL
review (Untitled3)
- member_id — bigint — Foreign key — NOT NULL
- mission_id — bigint — Foreign key — NOT NULL
- id (id2) — bigint — Foreign key — NOT NULL
- title — varchar(40) — NOT NULL
- body — varchar(100)
shop (Untitled4)
- id — bigint — Primary key — NOT NULL
- name — varchar(40) — NOT NULL
- introduce — varchar(100)
sunho_like (Untitled)
- Key — Primary key — NOT NULL
- name — varchar(40) — NOT NULL