fish
Tables (11)
bait (Untitled8)
- user_id (유저 식별자) — int — Foreign key → user.user_id — NOT NULL
- bait_count (미끼 수) — int
- create_at (생성일) — DATE
- update_at (수정일) — DATE
hunt (Untitled9)
- hunt_id (사냥 식별자) — int — Primary key — NOT NULL
- user_id (유저 식별자) — int — Primary key — NOT NULL
- target_user_id (타겟 유저 식별자) — int — Foreign key → user.user_id — NOT NULL
- create_at (생성일) — DATE
- update_at (수정일) — DATE
- status (상태) — char
images (Untitled2)
- images_id (이미지id) — int — Primary key — NOT NULL
- user_id (유저식별자) — int — Foreign key → user.user_id — NOT NULL
- file_name (파일 이름) — nvarchar2(600)
- create_at (생성일) — DATE
- stauts (사진상태) — char
like (Untitled7)
- like_id (좋아요 식별자) — int — Primary key — NOT NULL
- user_id (유저 식별자) — int — Primary key — NOT NULL
- target_user_id (타겟 유저 식별자) — int — Foreign key → user.user_id — NOT NULL
- create_at (생성일) — DATE
- update_at (수정일) — DATE
- status (상태) — char
location (Untitled4)
- location_id (지역 식별자) — int — Primary key — NOT NULL
- city_state_name (시도명) — nvarchar2(20)
- city_country_name (시군구명) — nvarchar2(20)
profile (Untitled3)
- user_id (유저 식별자) — int — Foreign key → user.user_id — NOT NULL
- hobby1 (취미1) — nvarchar2(50)
- hobby2 (취미2) — nvarchar2(50)
- hobby (취미3) — nvarchar2(50)
- introduce (한줄자기소개) — nvarchar2(900)
- create_at (생성일) — DATE
- update_at (수정일) — DATE
reporting_ reason (Untitled11)
- reporting_reason_id (신고사유 식별자) — int — Primary key — NOT NULL
- reporting_reason (신고 사유) — nvarchar2(200)
reporting_user (Untitled10)
- reporting_id (신고 식별자) — int — Primary key — NOT NULL
- user_id (유저 식별자) — int — Foreign key → user.user_id — NOT NULL
- reporting_reason_id (신고사유 식별자) — int — Foreign key → reporting_ reason.reporting_reason_id — NOT NULL
- target_user_id (타겟 유저 식별자) — int
- detail_reason (상세 사유) — nvarchar2(200)
- create_at (생성일) — DATE
- update_at (수정일) — DATE
- status (상태) — char
tag (Untitled5)
- tag_id (태그 식별자) — int — Primary key — NOT NULL
- tag_text (태그내용) — nvarchar2(20)
user (Untitled)
- user_id (유저 식별자) — int — Primary key — NOT NULL
- password (비밀번호) — nvarchar2(20)
- name (실명) — nvarchar2(20)
- phone_number (휴대폰번호) — nvarchar2(20)
- email (이메일) — nvarchar2(30)
- sex (성별) — char
- birth (출생년도) — DATE
- location_id (지역 식별자) — int — Foreign key → location.location_id — NOT NULL
- create_at (생성일) — DATE
- update_at (수정일) — DATE
- status (유저상태) — char
user_tag (Untitled6)
- tag_id (태그 식별자) — int — Foreign key → tag.tag_id — NOT NULL
- user_id (유저 식별자) — int — Foreign key → user.user_id — NOT NULL