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