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)