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