웹비디오에디터
테이블 (12)
channel (Untitled11)
- channel_id (Key) — number — 기본 키 — NOT NULL
- user_id (Key2) — varchar2 — 외래 키 → we_user.user_id — NOT NULL
- ch_info (Field) — varchar2
- ch_register (Field2) — date
- ch_image_url (Field3) — varchar2
- Field4
comment (Untitled4)
- reply_id (Key) — varchar2 — 기본 키 — NOT NULL
- table_id (Key3) — varchar2 — 외래 키 → we_board.board_id — NOT NULL
- user_id (Key2) — varchar2 — 외래 키 → we_user.user_id — NOT NULL
- reply_comment (Field) — varchar2
- reply_register (Field2) — date
favorites (Untitled6)
- fav_id (Key) — varchar2 — 기본 키 — NOT NULL
- user_id (Key2) — varchar2 — 외래 키 → we_user.user_id — NOT NULL
- table_id (Key3) — varchar2 — 외래 키 → we_board.board_id — NOT NULL
- fav_register (Field) — date
subscribe (Untitled9)
- user_id (Key) — varchar2 — 외래 키 → we_user.user_id — NOT NULL
- friend_id (Field) — varchar2
we_board (Untitled3)
- board_id (Key) — varchar2 — 기본 키 — NOT NULL
- user_id (Key2) — varchar2 — 외래 키 → we_user.user_id — NOT NULL
- video_id (Key3) — varchar2 — 외래 키 → we_video.video_id — NOT NULL
- tag (Field8) — varchar2
- name (Field) — varchar2
- count (Field2) — number
- comment (Field3) — varchar2
- like (Field4) — number
- hate (Field5) — number
- subscribe (Field6) — number
- register (Field7) — date
- show_or_not (Field9) — number
- video_alt (Field10) — varchar2
we_cloud_reply (이건 임시입니다)
- cloud_reply_id (Key) — varchar2 — 기본 키 — NOT NULL
- board_id (Key2) — varchar2 — 외래 키 → we_board.board_id — NOT NULL
- user_id (Key3) — varchar2 — 외래 키 → we_user.user_id — NOT NULL
- comment (Field) — varchar2
- video_time (Field2) — number
- video_cm_time (Field3) — number
we_hate (Untitled8)
- hate_id (Key) — varchar2 — 기본 키 — NOT NULL
- user_id (Key2) — varchar2 — 외래 키 → we_user.user_id — NOT NULL
- table_id (Key3) — varchar2 — 외래 키 → we_board.board_id — NOT NULL
we_like (Untitled7)
- kike_id (Key) — varchar2 — 기본 키 — NOT NULL
- user_id (Key2) — varchar2 — 외래 키 → we_user.user_id — NOT NULL
- table_id (Key3) — varchar2 — 외래 키 → we_board.board_id — NOT NULL
we_user (Untitled)
- user_id (Key) — varchar2 — 기본 키 — NOT NULL
- user_pw (Field) — varchar2
- user_name (Field2) — varchar2
- user_birth (Field3) — date
- user_email (Field4) — varchar2
- user_address (Field5) — varchar2
- register_date (Field6) — date
- last_login (Field7) — date
we_user_search_data (Untitled5)
- data_id (Key) — varchar2 — 기본 키 — NOT NULL
- user_id (Key2) — varchar2 — 외래 키 → we_user.user_id — NOT NULL
- search_title (Field) — varchar2
- favorite_tag (Field2) — varchar2
- subscribe (Field3) — varchar2
- video_alt (Field4) — varchar2
we_video (Untitled2)
- video_id (Key) — varchar2 — 기본 키 — NOT NULL
- user_id (Key2) — varchar2 — 외래 키 → we_user.user_id — NOT NULL
- video_url (Field3) — varchar2
- video_title_original (Field) — varchar2
- video_title_local (Field5) — varchar2
- size (Field2) — number
- type (Field4) — varchar2
- video_register (Field6) — date
we_video_edit (Untitled10)
- imsi (Key) — varchar2 — 기본 키 — NOT NULL
- video_url (Field) — varchar2
- video_title_original (Field2) — varchar2
- video_title_local (Field3) — varchar2