웹비디오에디터

테이블 (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