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)