ERDTable For Side Project
Tables (8)
Comments (Untitled6)
- comment_id (Key) — NOT NULL, UNIQUE — Primary key — NOT NULL
- post_id (Key2) — NOT NULL, UNIQUE — Foreign key → Post.post_id — NOT NULL
- user_id (Key3) — NOT NULL, UNIQUE — Foreign key → user.user_id — NOT NULL
- content (Field) — NOT NULL
- Field2 — NOT NULL
Hospital (Untitled3)
- hospital_id (Key) — NOT NULL, UNIQUE — Primary key — NOT NULL
- name (Field) — NOT NULL
- contact (Field2)
- address (Field3) — NULL
- office_day (Field4) — NULL
- office_time (Field5) — NULL
- hospital_type (Field6) — NULL
- coordinate_x (Field7)
- coordinate_y (Field8)
- updatedOn (Field9) — NULL
- createdOn (Field10) — NOT NULL
LIKE (Untitled7)
- LIKE_ID (Key4) — NOT NULL, UNIQUE — Primary key — NOT NULL
- user_id (Key) — Foreign key → user.user_id — NOT NULL
- post_id (Key2) — Foreign key → Post.post_id — NOT NULL
- comment_id (Key3) — Foreign key → Comments.comment_id — NOT NULL
Pharmacy (Untitled2)
- pharmacy_id (Key) — NOT NULL, UNIQUE — Primary key — NOT NULL
- name (Field) — NOT NULL
- contact (Field2)
- address (Field3)
- office_day (Field4)
- office_time (Field5)
- is_available (Field6)
- coordinate_x (Field7)
- coordinate_y (Field8)
- updatedOn (Field9) — NULL
- createdOn (Field10) — NOT NULL
Post (Untitled5)
- post_id (Key) — NOT NULL, UNIQUE — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.user_id — NOT NULL
- postname (Field) — NOT NULL
- content (Field2) — NOT NULL
- createdAt (Field3) — NOT NULL
- modifiedAt (Field4)
- post_type (Field5) — NOT NULL
- commentCnt (Field6)
- likeCnt (Field7)
Report (Untitled4)
- report_id (Key) — NOT NULL, UNIQUE — Primary key — NOT NULL
- user_id (Key2) — NOT NULL, UNIQUE — Foreign key → user.user_id — NOT NULL
- pharmacy_id (Key3) — NOT NULL, UNIQUE — Foreign key → Pharmacy.pharmacy_id — NOT NULL
- hospital_id (Key4) — NOT NULL, UNIQUE — Foreign key → Hospital.hospital_id — NOT NULL
- created_at (Field)
- comment (Field2)
social_user (Untitled)
- social_id (Key2) — NOT NULL, UNIQUE — Primary key — NOT NULL
- user_id (Key) — NOT NULL, UNIQUE — Foreign key → user.user_id — NOT NULL
- social_type (Field2) — NULL — NOT NULL — 네이버 로그인 API 설계 문서 기반
- social_profile (Field3) — NULL
- connected_date (Field4) — NULL
user (s)
- user_id (Key) — NOT NULL, UNIQUE — Primary key — NOT NULL
- username (Field5) — NOT NULL, UNIQUE
- password (Field6) — NOT NULL
- role (Field4) — NOT NULL
- date_created (Field2) — NOT NULL
- ispwdexpired (Field7) — NOT NULL
- last_password_changed (Field3) — NOT NULL
- account_locked (Field) — NOT NULL
- account_type (Field8) — NOT NULL