ubistudy

Tables (10)

fav_video

  • num (num2) — number — Foreign key → video_board.num — NOT NULL
  • id — varchar2(30) — NOT NULL
  • title — varchar2(50) — NOT NULL
  • num — number

free_board

  • ref — number — NOT NULL
  • re_level — number — NOT NULL
  • read_count — number — NOT NULL
  • title — varchar2(50)
  • content — varchar2(50)
  • pw — varchar2(50) — NOT NULL
  • day — date
  • num — number
  • id — varchar2(30) — Foreign key → member.id — NOT NULL
  • name — varchar2(30) — Foreign key → member.name — NOT NULL

member

  • id — varchar2(30) — Primary key — NOT NULL
  • name — varchar2(30) — Primary key — NOT NULL
  • num — number
  • point — number
  • id (id2) — varchar2(30) — NOT NULL
  • pw — varchar2(30) — NOT NULL
  • pnum — varchar2(30) — NOT NULL
  • nick — varchar2(20) — NOT NULL
  • grade — varchar2(10)
  • day — varchar2(30)
  • memo — varchar2(50)
  • image — varchar2(30)
  • fav — varchar2(30)
  • proof — varchar2(30)

message

  • id — varchar2(30) — Foreign key → member.id — NOT NULL
  • name — varchar2(30) — Foreign key → member.name — NOT NULL
  • num — number
  • count — number
  • to_id — varchar2(30) — NOT NULL
  • from_id — varchar2(30) — NOT NULL
  • title — varchar2(30) — NOT NULL
  • content — varchar2(100)
  • day — varchar2(30)

noti_board

  • num — number
  • read_count — number — NOT NULL
  • title — varchar2(50)
  • content — varchar2(50)
  • day — date

orders

  • id — varchar2(30) — Foreign key → member.id — NOT NULL
  • name — varchar2(30) — Foreign key → member.name — NOT NULL
  • num (num2) — number — Foreign key → video_board.num — NOT NULL
  • num (num22) — number — Foreign key → fav_video.num — NOT NULL
  • num — number
  • title — varchar2(50) — NOT NULL
  • price — number — NOT NULL

planer

  • id — varchar2(30) — Foreign key → member.id — NOT NULL
  • name — varchar2(30) — Foreign key → member.name — NOT NULL
  • id (id2) — varchar2(30) — Foreign key → study_board.id — NOT NULL
  • name (name2) — varchar2(30) — Foreign key → study_board.name — NOT NULL
  • num — number
  • nick — varchar2(30)
  • title — varchar2(30)
  • start_day — varchar2(100)
  • end_day — varchar2(100)
  • memo — varchar2(100)

review

  • num — number
  • id — varchar2(50) — NOT NULL
  • contents — varchar2(50)
  • title — varchar2(50) — NOT NULL
  • id (id2) — varchar2(30) — Foreign key → member.id — NOT NULL
  • name — varchar2(30) — Foreign key → member.name — NOT NULL
  • num (num2) — number — Foreign key → video_board.num — NOT NULL

study_board

  • id — varchar2(30) — Foreign key → member.id — NOT NULL
  • name — varchar2(30) — Foreign key → member.name — NOT NULL
  • num — number
  • ref — number — NOT NULL
  • re_level — number — NOT NULL
  • read_count — number — NOT NULL
  • nick — varchar2(20)
  • title — varchar2(50)
  • memo — varchar2(300)
  • start_day — varchar2(100)
  • end_day — varchar2(100)
  • day — varchar2(100)
  • pw — varchar2(50) — NOT NULL
  • flag — varchar2(200)
  • lang — varchar2(30) — NOT NULL
  • color — varchar2(15)

video_board

  • num — number — Primary key — NOT NULL
  • read_count — number — NOT NULL
  • name — varchar2(50)
  • title — varchar2(50)
  • content — varchar2(50)
  • day — date
  • price — number — NOT NULL
  • url — varchar2(100)
  • filename — varchar2(50)