UMC_ch04
Tables (9)
Inquiry (Untitled4)
- ID (Key) — int — Primary key — NOT NULL
- User_id (Key2) — int — Foreign key → USER.ID — NOT NULL
- Title (Field) — varchar(20)
- Body (Field2) — varchar(200)
- Field3
MISSION (Untitled2)
- ID (Key) — int — Primary key — NOT NULL
- Store_id (Key2) — int — Foreign key → STORE.ID — NOT NULL
- Description (Field) — varchar(20)
- reward (Field2) — int
NOTICE (Untitled3)
- ID (Key) — int — Primary key — NOT NULL
- User_id (Key2) — int — Foreign key → USER.ID — NOT NULL
- Title (Field2) — varchar(20)
- Body (Field3) — varchar(200)
PHONE_NUMBER (Untitled9)
- ID (Key) — int — Primary key — NOT NULL
- User_id (Key2) — int — Foreign key → USER.ID — NOT NULL
- Authorization (Field2) — enum
REGION (Untitled8)
- ID (Key) — int — Primary key — NOT NULL
- Field
- Field2
REVIEW (Untitled6)
- ID (Key) — int — Primary key — NOT NULL
- User_id (Key3) — int — Foreign key → USER.ID — NOT NULL
- Store_id (Key2) — int — Foreign key → STORE.ID — NOT NULL
- Body (Field) — varchar(20)
- Rating (Field2) — enum
STORE (Untitled5)
- ID (Key) — int — Primary key — NOT NULL
- Region_id (Key2) — int — Foreign key → REGION.ID — NOT NULL
- Name (Field3) — varchar(20)
- Info (Field) — varchar(200)
- Region (Field2) — enum
USER (Untitled)
- ID (Key) — int — Primary key — NOT NULL
- Email (Field) — varchar(20)
- Password (Field2) — varchar(20)
- Status (Field3) — enum
- Name (Field4) — varchar(20)
- Address (Field5) — varchar(20)
- Gender (Field6) — enum
- Birth (Field7) — varchar(20)
- Point (Field8) — long
USER-MISSION (Untitled7)
- ID (Key3) — int — Primary key — NOT NULL
- User_id (Key) — int — Foreign key → USER.ID — NOT NULL
- Mission_id (Key2) — int — Foreign key → MISSION.ID — NOT NULL
- Status (Field2) — enum
- created_at (Field) — datetime