UBI STUDY

Tables (9)

fav_video

  • num — number
  • id — varchar2(30) — NOT NULL
  • title — varchar2(50) — NOT NULL

free_board

  • num — number
  • ref — number — NOT NULL
  • re_level — number — NOT NULL
  • read_count — number — NOT NULL
  • name — varchar2(50)
  • title — varchar2(50)
  • content — varchar2(50)
  • pw — varchar2(50) — NOT NULL
  • day — date

member

  • num — number
  • point — number
  • id — varchar2(30) — NOT NULL
  • pw — varchar2(30) — NOT NULL
  • name — varchar2(20) — 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

  • Key — Primary key — 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

  • num — number
  • id — varchar2(30) — NOT NULL
  • title — varchar2(50) — NOT NULL
  • price — number — NOT NULL

review

  • num — number
  • id — varchar2(50) — NOT NULL
  • contents — varchar2(50)
  • title — varchar2(50) — NOT NULL

study_board

  • 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
  • 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)