fastcampus-9domain-par1

Tables (6)

USR (Untitled)

  • usr_id (Key) — varchar — Primary key — NOT NULL
  • usr_nm (Field)

USR_FOLLOW_INFO (Untitled2)

  • following_usr_id (Key2) — varchar — Primary key — NOT NULL
  • usr_id (Key) — varchar — Foreign key → USR.usr_id — NOT NULL

USR_PROFILE (Untitled3)

  • profile_seq (Key) — integer — Primary key — NOT NULL
  • profile_img_url (Field) — varchar
  • usr_id (Key2) — varchar — Foreign key → USR.usr_id — NOT NULL

board (Untitled4)

  • board_seq (Key) — integer — Primary key — NOT NULL
  • access_opt (Field) — varchar
  • board_content (Field2) — text
  • board_title (Field3)
  • usr_id (Key2) — varchar — Foreign key → USR.usr_id — NOT NULL
  • update_at (Field4) — timezone
  • create_at (Field5) — varchar

board_like (Untitled6)

  • usr_id (Key) — varchar — Foreign key → USR.usr_id — NOT NULL
  • board_seq (Key2) — integer — Foreign key → board.board_seq — NOT NULL

reply (Untitled5)

  • reply_seq (Key) — integer — Primary key — NOT NULL
  • board_seq (Key2) — integer — Foreign key → board.board_seq — NOT NULL
  • reply_content (Field)
  • usr_id (Key3) — varchar — Foreign key → USR.usr_id — NOT NULL
  • create_at (Field2) — timezone
  • update_at (Field3) — timezone