UMC_Assignment2
Tables (12)
alarms
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- is_confirmed (update_at) — boolean
- created_at (is_confirmed) — boolean
- updated_at (created_at) — datetime(6)
inquries
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- content — text
- is_answered — boolean
- answer — text
- created_at — datetime(6)
- updated_at — datetime(6)
member_mission
- id — bigint — Primary key — NOT NULL
- members_id (id2) — bigint — Foreign key → members.id — NOT NULL
- missions_id (id3) — bigint — Foreign key → missions.id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
member_preference (preferences)
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- preference_id (Key) — bigint — Foreign key → preference.id — NOT NULL
members
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- gender (nickname) — varchar(10)
- birthdate — datetime
- address — varchar(50)
- email — varchar(20)
- phone — varchar(15)
- point — bigint
- active — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
missions
- id — bigint — Primary key — NOT NULL
- store_id (id2) — bigint — Foreign key → stores.id — NOT NULL
- content — text
- point — int
- in_progress (is_progress) — boolean
- is_done — boolean
new_mission
- id — bigint — Primary key — NOT NULL
- alarms_id (id2) — bigint — Foreign key → alarms.id — NOT NULL
- title — varchar(20)
- body — text
preference (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- preference (Field) — varchar(20)
request_review
- id — bigint — Primary key — NOT NULL
- alarms_id (id2) — bigint — Foreign key → alarms.id — NOT NULL
- title — varchar(20)
- body — text
reviews
- id — bigint — Primary key — NOT NULL
- store_id — bigint — Foreign key → stores.id — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- content — text
- score — float
- image — imagefield
- created_at — datetime(6)
- updated_at — datetime(6)
store_type
- id — bigint — Primary key — NOT NULL
- type — varchar(20)
stores
- id — bigint — Primary key — NOT NULL
- store_type_id — bigint — Foreign key → store_type.id — NOT NULL
- store_name (Field) — varchar(20)
- address (Field2) — varchar(50)
- latitude (Field3) — float
- longitude (Field4) — float
- is_opened (Field5) — boolean
- created_at — datetime(6)
- updated_at — datetime(6)