UMC 1주차 과제

테이블 (16)

Untitled (food)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(20)

Untitled (like)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (food_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • pk (user_id) — bigint — 외래 키 → user.pk — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (mission)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (market_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — varchar(20)
  • Field (end_date) — datetime(6)
  • Field (point) — int
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (market)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (place_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — varchar(20)
  • Field (type) — bigint
  • Field (start_time) — time
  • Field (end_time) — time
  • Field (address) — varchar(128)
  • Field (star) — double
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field

Untitled (comment)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (market_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • pk (user_id) — bigint — 외래 키 → user.pk — NOT NULL
  • Field2 (writer) — varchar(20)
  • Field (star) — double
  • Field (content) — varchar(256)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (marketImage)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (market_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (url) — varchar(256)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (commentImage)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (comment_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (url) — varchar(256)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (commentReply)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (comment_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — varchar(256)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (userMission)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • pk (user_id) — bigint — 외래 키 → user.pk — NOT NULL
  • Key (mission_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (status) — boolean
  • Field (review) — varchar(128)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (place)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(20)

Untitled (alarm)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • pk (user_id) — bigint — 외래 키 → user.pk — NOT NULL
  • Field (content) — varchar(100)
  • Field (is_read) — boolean
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (inquiry)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (title) — varchar(128)
  • Field (type) — varchar(10)
  • Field (content) — varchar(255)
  • Field (is_done) — boolean
  • pk (user_id) — bigint — 외래 키 → user.pk — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (inquiryImage)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (inquiry_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (url) — varchar(255)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (inquiryReply)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (inquiry_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — varchar(256)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (point)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • pk (user_id) — bigint — 외래 키 → user.pk — NOT NULL
  • Field (point) — int
  • Field (is_plus) — boolean

user

  • pk (id) — bigint — 기본 키 — NOT NULL
  • 이름 (username) — varchar(20)
  • Field (birth) — datetime(6)
  • Field (city) — varchar(20)
  • Field (address) — varchar(20)
  • Field (gender) — varchar(10)
  • Field (point) — bigint
  • Field (phone_num) — varchar(20)
  • Field (phoen_valid) — boolean
  • Field (email) — varchar(254)
  • Field (new_event_agree) — boolean
  • Field (review_reply_alarm) — boolean
  • Field (ask_answer_alarm) — boolean
  • Field (status) — varchar(15)
  • Field (inactive_date) — datetime(6)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)