제대로

테이블 (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