Spring
Tables (10)
Copy Of Untitled (SHOP)
- Key (SHOP_ID) — VARCHAR(30) — Primary key — NOT NULL
- Field (SHOP_LOCATION) — VARCHAR(30)
- Field2 (SHOP_INFO) — VARCHAR(100)
- Field (CREATED_TIME) — DATETIME(6)
- Field (UPDATED_TIME) — DATETIME(6)
Untitled (FOOD)
- Key (FOOD_NAME) — VARCHAR(30) — Primary key — NOT NULL
- Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled3.Key
- Field (CREATED_TIME) — DATETIME(6)
- Field2 (UPDATED_TIME) — DATETIME(6)
Untitled (MISSION)
- Key (mission_Id) — int — Primary key — NOT NULL
- Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled3.Key
- Field (mission_name) — VARCHAR(40)
- Field (content) — int
- Field (mission_point) — int
- Field (status) — ENUM('진행중','진행완료')
- Field (Created_time) — DATETIME(6)
- Field2 (FINISED_TIME) — DATETIME(6)
- Key (SHOP_ID) — VARCHAR(30) — Foreign key → Copy Of Untitled.Key — NOT NULL
Untitled (MAP)
- Key (map_id) — VARCHAR(20) — Primary key — NOT NULL
- Key (SHOP_ID) — VARCHAR(30) — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field2 (shop_info) — VARCHAR(50)
Untitled (alram)
- Key (alram_id) — int — Primary key — NOT NULL
- Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled3.Key
Untitled (mission_notice)
- Key (id) — int — Primary key — NOT NULL
- Key (alram_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (review) — int — Foreign key → Untitled.Key — NOT NULL
- Key (mission_Id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled.Key
- Field (content) — text
Untitled (review)
- Key (review) — int — Primary key — NOT NULL
- Key (mission_Id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled.Key
- Field (content) — text
- Field (CREATED_TIME) — DATETIME(6)
- Field2 (UPDATED_TIME) — DATETIME(6)
- Field (RATING) — int
Untitled (Comment)
- Key (comment_id) — LONG — Primary key — NOT NULL
- Key (review) — int — Foreign key → Untitled.Key — NOT NULL
- Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled3.Key
- Field (길이) — LONG
- Field (Content) — VARCHAR(100)
- Field (CREATED_TIME) — DATETIME(6)
- Field2 (UPDATED_TIME) — DATETIME(6)
Untitled3 (MEMBER)
- Key (MEMBER_ID) — VARCHAR(20) — Primary key
- Field (NICK_NAME) — TEXT
- Field (PHONE_NUM) — int
- Field2 (EMAIL) — VARCHAR(50)
- Field (PASSWORD) — VARCHAR(50)
- Field2 (GENDER) — ENUM('남','여')
- Field3 (BIRTH) — VARCHAR(6)
- Field (ADDRESS) — VARCHAR(100)
- Field (status) — varchar(15)
- Field (inactive_time) — DATETIME(6)
- Field (CREATED_TIME) — DATETIME(6)
- Field (UPDATED_TIME) — DATETIME(6)