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