Opendoors

Tables (11)

BOARD (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → USER.id — NOT NULL
  • title (Field) — varchar(255) — NOT NULL
  • content (Field2) — varchar(255) — NOT NULL
  • created_at (Field3) — datetime — NOT NULL
  • updated_at (Field4) — datetime — NOT NULL

BOOKMARK (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → USER.id — NOT NULL
  • place_id (Key3) — int — Foreign key → PLACE.id — NOT NULL

PLACE (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(50) — NOT NULL
  • location (Field2) — varchar(100) — NOT NULL
  • category (Field3) — varchar(255) — NOT NULL
  • rating (Field4) — int — NOT NULL

PLACE_IMG (Untitled9)

  • id (Key) — int — Primary key — NOT NULL
  • place_id (Key2) — int — Foreign key → PLACE.id — NOT NULL
  • file_url (Field) — varchar(255) — NOT NULL
  • name (Field2) — varchar(255) — NOT NULL
  • type (Field3) — varchar(255) — NOT NULL

PLACE_INFORMATION (Untitled11)

  • id (Key) — place_id — Primary key — NOT NULL
  • place_id (Key2) — int — Foreign key → PLACE.id — NOT NULL
  • information (Field) — varchar(255) — NOT NULL

PLACE_REVIEW (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • place_id (Key2) — int — Foreign key → PLACE.id — NOT NULL
  • user_id (Field2) — int — NOT NULL
  • content (Field) — varchar(255) — NOT NULL

POINT (Untitled6)

  • user_id (Key) — int — Foreign key → USER.id — NOT NULL
  • score (Field) — int — NOT NULL

REPLY (Untitled8)

  • id (Key) — int — Primary key — NOT NULL
  • board_id (Key3) — int — Foreign key → BOARD.id — NOT NULL
  • user_id (Field4) — int — NOT NULL
  • content (Field) — varchar(255) — NOT NULL
  • created_at (Field2) — datetime — NOT NULL
  • updated_ad (Field3) — datetime — NOT NULL

USER (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • username (Field) — char(20) — NOT NULL
  • password (Field2) — char(16) — NOT NULL
  • name (Field3) — char(20) — NOT NULL
  • birth (Field4) — datetime — NOT NULL
  • gender (Field5) — char(1) — NOT NULL
  • role (Field6) — char(20) — NOT NULL
  • created_at (Field7) — datetime — NOT NULL
  • updated_at (Field8) — datetime — NOT NULL

USER_IMG (Untitled10)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → USER.id — NOT NULL
  • file_url (Field) — varchar(255) — NOT NULL
  • name (Field2) — varchar(255) — NOT NULL
  • type (Field3) — varchar(255) — NOT NULL

USER_PREFERENCE (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → USER.id — NOT NULL
  • preference (Field) — varchar(255) — NOT NULL