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