UMC_Week1
Tables (8)
Member (member)
- Member Id (id) — BIGINT — Primary key
- Name (name) — varchar — NOT NULL
- Email (email) — varchar — NOT NULL
- Created Date (created_at) — timestamp — NOT NULL
- Updated Date (updated_at) — timestamp
- Deleted Date (deleted_at) — timestamp
Mission (mission)
- Mission id (id) — BIGINT — Primary key — NOT NULL
- store id (id2) — BIGINT — Foreign key → store.store id — NOT NULL
- title — varchar — NOT NULL
- Description (description) — varchar
- Phone number (phone_number) — varchar
- Created Date (created_at) — timestamp — NOT NULL
- Updated Date (updated_at) — timestamp
- Deleted Date (deleted_at) — timestamp
- reward point (reward_point) — int — NOT NULL
food category (food_category)
- food category id (id) — BIGINT — Primary key
- category name (name) — varchar — NOT NULL
- Created Date (created_at) — timestamp — NOT NULL
- Updated Date (updated_at) — timestamp
- Deleted Date (deleted_at) — timestamp
member_food_category
- food category id (id) — BIGINT — Primary key
- Member Id (member.id) — BIGINT — Foreign key → Member.Member Id
- food category id (id2) — BIGINT — Foreign key → food category.food category id
- category name (name) — varchar — NOT NULL
- Created Date (created_at) — timestamp — NOT NULL
- Updated Date (updated_at) — timestamp
- Deleted Date (deleted_at) — timestamp
member_mission
- MemeberMission id (id) — BIGINT — Primary key — NOT NULL
- store id (id2) — BIGINT — Foreign key → store.store id — NOT NULL
- title — varchar — NOT NULL
- status — varchar
- Created Date (created_at) — timestamp — NOT NULL
- Updated Date (updated_at) — timestamp
- Deleted Date (deleted_at) — timestamp
- reward point (reward_point) — int — NOT NULL
- Mission id (id3) — BIGINT — Foreign key → Mission.Mission id — NOT NULL
member_social_account
- id — BIGINT — Primary key
- Member Id (member.id) — BIGINT — Foreign key → Member.Member Id
- provider — varchar
- provider_user_id — varchar
- Created Date (created_at) — timestamp — NOT NULL
- Updated Date (updated_at) — timestamp
- Deleted Date (deleted_at) — timestamp
region
- region id (id) — BIGINT — Primary key
- Name (name) — varchar — NOT NULL
- Created Date (created_at) — timestamp — NOT NULL
- Updated Date (updated_at) — timestamp
- Deleted Date (deleted_at) — timestamp
store
- store id (id) — BIGINT — Primary key — NOT NULL
- region id (id2) — BIGINT — Foreign key → region.region id
- food category id (id3) — BIGINT — Foreign key → food category.food category id
- name — varchar — NOT NULL
- address — varchar — NOT NULL
- Description (description) — varchar
- Phone number (phone_number) — varchar
- Created Date (created_at) — timestamp — NOT NULL
- Updated Date (updated_at) — timestamp
- Deleted Date (deleted_at) — timestamp