fish_market

Tables (5)

Comment (user_comment)

  • comment_id (답글 ID) — NOT NULL — Primary key — NOT NULL
  • post_id (게시글ID) — char(5) — Foreign key → Post.post_id — NOT NULL
  • user_id (사용자 ID) — number — Foreign key → User_Profile.user_id — NOT NULL
  • content (답글 내용) — varchar(100)
  • created_at (답글 생성 날짜) — date
  • updated_at (답글 수정 날짜) — date

Image (image)

  • image_id (이미지ID) — number — Primary key — NOT NULL
  • user_id (사용자 ID) — number — Foreign key → User_Profile.user_id — NOT NULL
  • url (이미지 주소) — varchar(100)

Post (user_post)

  • post_id (게시글ID) — number — Primary key — NOT NULL
  • user_id (사용자 ID) — number — Foreign key → User_Profile.user_id — NOT NULL
  • title (제목) — varchar(100)
  • content (내용) — varchar(500)
  • created_at (생성 날짜) — date
  • updated_at (수정 날짜) — date

User (users)

  • user_id (사용자 ID) — number — Primary key — NOT NULL
  • email (이메일) — varchar(100)
  • created_at (생성 시각) — date

User_Profile (profile)

  • user_id (사용자 ID) — number — Foreign key → User.user_id — NOT NULL
  • username (이름) — varchar(100)
  • date_of_birth (생일) — date
  • gender (성별) — varchar(1)
  • address (주소) — varchar(100)
  • phone_number (핸드폰 번호) — number
  • photo_id (이미지ID) — char(5)
  • activity_type (사장님/고객) — date