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