UMC-5th-mission
Tables (6)
Member (member)
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- gender — varchar(10)
- birth — datetime
- address — varchar(40)
- food_type — varchar(20)
- status — varchar(15)
- inactive_data — datetime
- userId — varchar(40)
- pw — varchar(40)
- email — varchar(50)
- phone_number — varchar(10)
- point — int
- updated_at — datetime(6)
- careated_at — datetime(6)
MemberMission (memberMission)
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → Member.id — NOT NULL
- mission_id — bigint — Foreign key → Mission.id — NOT NULL
- state — varchar(15)
- created_at — datetime(6)
- updated_at — datetime(6)
Mission (mission)
- id — bigint — Primary key — NOT NULL
- reward — int
- deadline — datetime
- content — text
- created_at — datetime(6)
- updated_at — datetime(6)
Review (review)
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → Member.id — NOT NULL
- store_id — bigint — Foreign key → Store.id — NOT NULL
- score — float
- content — text
- created_at — datetime(6)
- updated_at — datetime(6)
ReviewImage (reviewImage)
- id — bigint — Primary key — NOT NULL
- review_id — bigint — Foreign key → Review.id — NOT NULL
- image_url — text
- created_at — datetime(6)
- updated_at — datetime(6)
Store (store)
- id — bigint — Primary key — NOT NULL
- address — varchar(40)
- score — float
- name — varchar(10)
- created_at — datetime(6)
- updated_at — datetime(6)