bewithme

Tables (14)

bookmark (북마크)

  • num (Key) — int — Primary key — NOT NULL
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL
  • cou_num (Key3) — int — Foreign key → course.cou_num — NOT NULL

calendar (캘린더)

  • cal_num — int — Primary key — NOT NULL
  • start_date — varchar(100) — NOT NULL
  • end_date — varchar(100) — NOT NULL
  • url — varchar(200)
  • cal_content — text — NOT NULL
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL

chat (채팅(qna))

  • chat_num (Key) — int — Primary key — NOT NULL
  • from_id — varchar(100)
  • to_id — varchar(100)
  • chat_content — varchar(200)
  • chat_time — datetime

chat_bot (챗봇(qna))

  • bot_num — int — Primary key — NOT NULL
  • title_content — varchar(200) — NOT NULL
  • btn_content — varchar(100) — NOT NULL
  • bot_content — varchar(100) — NOT NULL
  • count — int
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL

com_comment (커뮤니티 댓글)

  • com_com_num (Key) — int — Primary key — NOT NULL
  • com_com_content (Field) — text — NOT NULL
  • com_com_reg_date (Field2) — datetime
  • com_com_mod_date (Field3) — datetime
  • nickname (Field4) — varchar(100) — NOT NULL
  • com_com_isMod (Field5) — varchar(50)
  • com_com_like_cnt (Field6) — int
  • com_num (Key2) — int — Foreign key → community.com_num — NOT NULL
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL

com_comment_like (커뮤니티 댓글 좋아요)

  • num (Key2) — int — Primary key — NOT NULL
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL
  • com_com_num (Key) — int — Foreign key → com_comment.com_com_num — NOT NULL

com_file (커뮤니티 파일)

  • com_file_uuid (Key) — varchar(256) — Primary key — NOT NULL
  • com_file_save_dir (Field) — varchar(256) — NOT NULL
  • com_file_name (Field2) — varchar(256) — NOT NULL
  • com_file_type (Field3) — tinyint(1)
  • com_file_size (Field4) — int
  • com_file_reg_date (Field5) — datetime
  • com_num (Key2) — int — Foreign key → community.com_num — NOT NULL

community (커뮤니티)

  • com_num (Key) — int — Primary key — NOT NULL
  • com_title (Field) — varchar(100) — NOT NULL
  • com_content (Field2) — text — NOT NULL
  • com_cnt (Field3) — int
  • com_category (Field4) — varchar(100) — NOT NULL
  • com_reg_date (Field5) — datetime
  • com_isDel (Field6) — varchar(50)
  • com_like_cnt (Field7) — int
  • com_comment_cnt (Field9) — int
  • com_mod_date (Field10) — datetime
  • nickname (Field8) — varchar(100)
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL

community_like (커뮤니티 좋아요)

  • num (Key2) — int — Primary key — NOT NULL
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL
  • com_num (Key) — int — Foreign key → community.com_num — NOT NULL

cou_comment (수강 댓글)

  • cou_com_num (Key) — int — Primary key — NOT NULL
  • cou_com_content (Field) — text — NOT NULL
  • cou_com_reg_time (Field2) — datetime
  • cou_com_mod_date (Field3) — datetime
  • cou_com_isMod (Field5) — varchar(50)
  • nickname (Field4) — varchar(100)
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL
  • cou_num (Key3) — int — Foreign key → course.cou_num — NOT NULL

course (수강)

  • cou_num (Key3) — int — Primary key — NOT NULL
  • cou_title (Field6) — varchar(100) — NOT NULL
  • cou_content (Field2) — text — NOT NULL
  • cou_cnt (Field4) — int — NOT NULL
  • cou_reg_date (Field3) — datetime
  • cou_isDel (Field5) — varchar(50)
  • summary (Field) — varchar(500)
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL
  • sub_num (Key2) — int — Foreign key → subject.sub_num — NOT NULL

subject (과목)

  • sub_num (Key) — int — Primary key — NOT NULL
  • sub_title (Field) — varchar(100) — NOT NULL
  • sub_reg_date (Field2) — datetime
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL

todo (투두리스트)

  • todo_num (Key) — int — Primary key — NOT NULL
  • todo_content (Field) — varchar(200) — NOT NULL
  • id (uno) — varchar(100) — Foreign key → user.id — NOT NULL
  • idDel (Field2) — varchar(10)

user (유저)

  • id (uno) — varchar(100) — Primary key — NOT NULL
  • pw (Field) — varchar(100) — NOT NULL
  • reg_date (Field5) — datetime
  • admin (Field6) — tinyint(1) — NOT NULL — 0 = 사용자
  • nickname (Field7) — varchar(100) — NOT NULL