(modifying)umc_week1
Tables (14)
inquiry
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- title — varchar(50)
- body — varchar(500)
- created_at — datetime(6)
- updated_at — datetime(6)
- dtype — enum
- images — text
inquiry_answer (answer)
- id — bigint — Primary key — NOT NULL
- inquiry_id — bigint — Foreign key → inquiry.id — NOT NULL
- created_at — datetime(6)
- updated_at (updated_at2) — datetime(6)
- title — varchar(50)
- body — text
member
- id — bigint — Primary key — NOT NULL
- user_password — varchar(255)
- name — varchar(40)
- nickname — varchar(20)
- phone_number — varchar(15)
- gender — enum
- birthday — datetime(6)
- email — varchar(30)
- address — varchar(100)
- status — enum
- inactive_date — datetime
- created_at — datetime(6)
- updated_at — datetime(6)
mission
- id — bigint — Primary key — NOT NULL
- store_id — bigint — Foreign key → store.id — NOT NULL
- title — varchar(50)
- body — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
- deadline — datetime(6)
my_mission
- id — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- dtype — enum
new_event
- id — bigint — Primary key — NOT NULL
- push_id — bigint — Foreign key → push_notification.id — NOT NULL
- title — varchar(50)
- body — varchar(255)
push_notification
- id — bigint — Primary key — NOT NULL
- is_confirmed — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
- member_id — bigint — Foreign key → member.id — NOT NULL
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
- contents — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
- score — int
- images — text
review_answer
- id — bigint — Primary key — NOT NULL
- push_id — bigint — Foreign key → push_notification.id — NOT NULL
- title — varchar(50)
- body — varchar(255)
review_comment
- id — bigint — Primary key — NOT NULL
- review_id — bigint — Foreign key → review.id — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
store
- id — bigint — Primary key — NOT NULL
- name — varchar(30)
- address — varchar(100)
tag
- id — bigint — Primary key — NOT NULL
- store_id — bigint — Foreign key → store.id — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- title — varchar(15)
terms
- id — bigint — Primary key — NOT NULL
- title — varchar(50)
- body — varchar(255)
- essential — enum
terms_agreement
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- agreement_id — bigint — Foreign key → terms.id — NOT NULL
- agreement — enum
- agreement_at — datetime(6)