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