fish_count

Tables (4)

file (녹화 완료 파일)

  • file_id — int — Primary key — NOT NULL
  • streaming_id — int — Foreign key → streaming.streaming_id — NOT NULL
  • file_name — varchar(200)
  • fila_path — varchar(200)
  • file_size — int
  • reg_date — datetime

fishing_ground (어장)

  • gound_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • ground_name — varchar(100)
  • ground_address — varchar(200)
  • deleted_yn — varchar(1)
  • Field

streaming (스트리밍)

  • streaming_id — int — Primary key — NOT NULL
  • stream_key — varchar(100) — Primary key — NOT NULL
  • gound_id — int — Foreign key → fishing_ground.gound_id — NOT NULL
  • start_time — datetime
  • end_time — datetime — NOT NULL
  • streaming_stat — varchar(1) — NOT NULL
  • count — int

user (이용자)

  • user_id — int — Primary key — NOT NULL
  • username — varchar(20) — Primary key — NOT NULL
  • user_email — varchar(50) — Primary key — NOT NULL
  • password — varchar(200)
  • tel_num — varchar(13)
  • address — varchar(200)