UMC_DB_4week_solution
Tables (17)
alram
- id — bigint — Primary key — NOT NULL
- title — varchar(20)
- optional — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
alram_agree
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- member_id — bigint — Foreign key → member.id — NOT NULL
- alram_id — bigint — Foreign key → alram.id — NOT NULL
food_category
- id — bigint — Primary key — NOT NULL
- name — varchar(15)
- created_at — datetime(6)
- updated_at — datetime(6)
member
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- gender — varchar(10)
- age — int
- address — varchar(40)
- spec_address — varchar(40)
- status — varchar(15)
- inactive_date — datetime
- social_type — varchar(10)
- email — varchar(50)
- point — int
- created_at — datetime(6)
- updated_at — datetime(6)
- phone_authentication — boolean
- profile_image — blob
member_agree
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- member_id — bigint — Foreign key → member.id — NOT NULL
- terms_id — bigint — Foreign key → terms.id — NOT NULL
member_mission
- id — bigint — Primary key — NOT NULL
- status — varchar(15)
- created_at — datetime(6)
- updated_at — datetime(6)
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
member_mission_region
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- region_id — bigint — Foreign key → region.id — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- mission_region_status — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
member_prefer
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- member_id — bigint — Foreign key → member.id — NOT NULL
- category_id — bigint — Foreign key → food_category.id — NOT NULL
mission
- id — bigint — Primary key — NOT NULL
- reward — int
- deadline — datetime
- mission_spec — text
- created_at — datetime(6)
- updated_at — datetime(6)
- store_id — bigint — Foreign key → store.id — NOT NULL
- alram_id — bigint — Foreign key → alram.id — NOT NULL
qna
- id — bigint — Primary key — NOT NULL
- title — varchar(30)
- body — text
- is_confirmed — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
- member_id — bigint — Foreign key → member.id — NOT NULL
- alram_id — bigint — Foreign key → alram.id — NOT NULL
qna_image
- id — bigint — Primary key — NOT NULL
- image_url — text
- created_at — datetime(6)
- updated_at — datetime(6)
- qna_id — bigint — Foreign key → qna.id — NOT NULL
region
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
review
- id — bigint — Primary key — NOT NULL
- body — text
- score — float
- created_at — datetime(6)
- updated_at — datetime(6)
- store_id — bigint — Foreign key → store.id — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- alram_id — bigint — Foreign key → alram.id — NOT NULL
review_image
- id — bigint — Primary key — NOT NULL
- image_url — text
- created_at — datetime(6)
- updated_at — datetime(6)
- review_id — bigint — Foreign key → review.id — NOT NULL
review_reply
- id — bigint — Primary key — NOT NULL
- reply_text — text
- created_at — datetime(6)
- updated_at — datetime(6)
- store_id — bigint — Foreign key → store.id — NOT NULL
- review_id — bigint — Foreign key → review.id — NOT NULL
store
- id — bigint — Primary key — NOT NULL
- name — varchar(50)
- address — varchar(50)
- score — float
- created_at — datetime(6)
- updated_at — datetime(6)
- region_id — bigint — Foreign key → region.id — NOT NULL
- food_category_id — bigint — Foreign key → food_category.id — NOT NULL
terms
- id — bigint — Primary key — NOT NULL
- title — varchar(20)
- body — text
- optional — boolean
- created_at — datetime(6)
- updated_at — datetime(6)