IWasTheKey
Tables (7)
COMMENTS (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- comment (Field1) — TEXT — NOT NULL
- created_at (Field2) — TIMESTAMP — NOT NULL
- user_id (Key2) — INT — Foreign key → USER.id — NOT NULL
- post_id (Key3) — INT — Foreign key → POSTS.id — NOT NULL
LIKE (Untitled3)
- id (Key) — INT — Primary key — NOT NULL
- created_at (Field) — TIMESTAMP — NOT NULL
- user_id (Key2) — INT — Foreign key → USER.id — NOT NULL
- post_id (Key3) — INT — Foreign key → POSTS.id — NOT NULL
POSTS (Untitled2)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT — NOT NULL
- type (Field2) — ENUM — NOT NULL
- title (Field3) — VARCHAR(100)) — NOT NULL
- content (Field4) — TEXT — NOT NULL
- created_at (Field5) — TIMESTAMP — NOT NULL
- Field6
- id (Key2) — INT — Foreign key → USER.id — NOT NULL — primary key
RESERVATION (Untitled6)
- id (Key) — INT — Primary key — NOT NULL
- reservation_date (Field) — DATE — NOT NULL
- user_id (Key2) — INT — Foreign key → USER.id — NOT NULL
- theme_id (Key3) — INT — Foreign key → THEME.id — NOT NULL
REVIEW (Untitled5)
- id (Key) — INT — Primary key — NOT NULL
- content (Field) — TEXT — NOT NULL
- rating (Field2) — INT — NOT NULL — rating BETWEEN 1 AND 5
- created_at (Field3) — TIMESTAMP — NOT NULL
- user_id (Key2) — INT — Foreign key → USER.id — NOT NULL
- theme_id (Key3) — INT — Foreign key → THEME.id — NOT NULL
THEME (Untitled4)
- id (Key) — INT — Primary key — NOT NULL
- external_id (Field) — VARCHAR(100) — NOT NULL — unique
- name (Field2) — VARCHAR(100) — NOT NULL
- region (Field3) — VARCHAR(50) — NOT NULL
- company (Field4) — VARCHAR(100) — NOT NULL
- rating_avg (Field5) — FLOAT — NOT NULL
- review_count (Field6) — INT — NOT NULL
USER
- id (Key) — INT — Primary key — NOT NULL
- nickname (Field) — VARCHAR(50) — unique
- profile_image_url (Field2) — VARCHAR(255)
- social_type (Field3) — ENUM — NOT NULL — "GOOGLE", "KAKAO"
- created_at (Field4) — TIMESTAMP — NOT NULL
- updated_at (Field5) — TIMESTAMP — NOT NULL