제대로
테이블 (11)
Untitled (UNIVERSITY)
- Key (university_id) — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR
- Field2 (latitude) — DOUBLE
- Field (longitude) — DOUBLE
- Field (created_time) — LOCALDATETIME
- Field (modified_time) — LOCALDATETIME
Untitled (PICK)
- Key (pick_id) — BIGINT — 기본 키 — NOT NULL
- Key (store_id) — BIGINT — 외래 키 → 가게.Key — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → 사용자.Key — NOT NULL
- Field (created_time) — LOCALDATETIME
- Field (modified_time) — LOCALDATETIME
Untitled (BUSINESSHOUR)
- Key (businesshour_id) — BIGINT — 기본 키 — NOT NULL
- Key (store_id) — BIGINT — 외래 키 → 가게.Key — NOT NULL
- Field (opening_time) — VARCHAR
- Field2 (closing_time) — VARCHAR
- Field (created_time) — LOCALDATETIME
- Field (modified_time) — LOCALDATETIME
Untitled (POPUP)
- Key (popup_id) — BIGINT — 기본 키 — NOT NULL
- Key (store_id) — BIGINT — 외래 키 → 가게.Key — NOT NULL
- Key (contract_id) — BIGINT — 외래 키 → 제안.Key — NOT NULL
- Field (title) — VARCHAR
- Field (content) — VARCHAR
- Field (startdate) — LOCALDATE
- Field (enddate) — LOCALDATE
- Field (reservation) — LOCALDATETIME
- Field (created_time) — LOCALDATETIME
- Field (modified_time) — LOCALDATETIME
Untitled (EVENT)
- Key (event_id) — BIGINT — 기본 키 — NOT NULL
- Key (contract_id) — BIGINT — 외래 키 → 제안.Key — NOT NULL
- Field (type) — VARCHAR
- Field2 (count) — INT
- Field (created_time) — LOCALDATETIME
- Field (modified_time) — LOCALDATETIME
Untitled (USAGEDETAILS)
- Key (usage_details_id) — BIGINT — 기본 키 — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → 사용자.Key — NOT NULL
- Key (store_id) — BIGINT — 외래 키 → 가게.Key — NOT NULL
- Field (stamp) — INT
- Field (benefit_amount) — INT
- Field (created_time) — LOCALDATETIME
- Field (modified_time) — LOCALDATETIME
Untitled (CONDITIONS)
- Key (condition_id) — BIGINT — 기본 키 — NOT NULL
- Key (event_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (content) — STRING
가게 (STORE)
- Key (store_id) — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR
- Field (address) — VARCHAR
- Field (description) — VARCHAR
- Field (longitude) — DOUBLE
- Field (latitude) — DOUBLE
- Field (category) — VARCHAR
- Field (contact) — VARCHAR
- Field (map_url) — VARCHAR
- Field (phone) — VARCHAR
- Field (created_time) — LOCALDATETIME
- Field (modified_time) — LOCALDATETIME
사용자 (USER)
- Key (user_id) — BIGINT — 기본 키 — NOT NULL
- Key (university_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (email) — VARCHAR
- Field (password) — VARCHAR
- Field (type) — VARCHAR
- Field (type_name) — VARCHAR
- Field (img_url) — VARCHAR
- Field (refresh_token) — VARCHAR
- Field (created_time) — LOCALDATETIME
- Field (modified_time) — LOCALDATETIME
제안 (CONTRACT)
- Key (contract_id) — BIGINT — 기본 키 — NOT NULL
- Key (store_id) — BIGINT — 외래 키 → 가게.Key — NOT NULL
- Key (university_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (status) — VARCHAR
- Field (start_date) — DATETIME
- Field (end_date) — DATETIME
- Field (manager) — VARCHAR
- Field (created_time) — LOCALDATETIME
- Field (modified_time) — LOCALDATETIME
혜택 (BENEFIT)
- Key (benefit_id) — BIGINT — 기본 키 — NOT NULL
- Key (contract_id) — BIGINT — 외래 키 → 제안.Key — NOT NULL
- Field (content) — VARCHAR
- Field (created_time) — LOCALDATETIME
- Field (modified_time) — LOCALDATETIME