ㅇㅇ
Tables (11)
1chon (1촌)
- 1chon_id (일촌기보ㅋㄴ키) — Primary key — NOT NULL
- user_id (기본키) — number — Foreign key → cy_user.user_id — NOT NULL
- user_id (기본키2) — number — Foreign key → cy_user.user_id — NOT NULL
bgm (브금)
- bgm_id (기본키) — number — Primary key — NOT NULL
- song_name (타이틀) — varchar
- singer (가수명) — varchar
- file_route (파일루트) — varchar
- origin-file_name (찐파일명) — varchar
- order (순서) — number
- use_Yn (사용여부) — varchar?
- homp_id (기본키2) — number — Foreign key → cy_minihome.homp_id — NOT NULL
cy_diary (다이어리)
- diary_id (기본키) — number — Primary key — NOT NULL
- content (Field) — blob
- title (제목) — varchar
- homp_id (기본키2) — number — Foreign key → cy_minihome.homp_id — NOT NULL
cy_galary (사진첩)
- galary_id (기본키) — number — Primary key — NOT NULL
- content (Field) — blob
- title (제목) — varchar
- homp_id (기본키2) — number — Foreign key → cy_minihome.homp_id — NOT NULL
cy_minihome (미니홈피)
- homp_id (기본키) — number — Primary key — NOT NULL
- title (미니홈피) — varchar
- emotion (감정) — number
- msg (상메?) — varchar
- private_degree (오픈정도) — number
- galary_yn (갤러리사용여부) — number
- board_yn (게시판사용여부) — number
- diary_yn (다이어리사용여뷰) — num
- visitor_yn (Field)
- emotion_id (기본키2) — number — Foreign key → emotion.emotion_id — NOT NULL
- user_id (기본키3) — number — Foreign key → cy_user.user_id — NOT NULL
cy_sub_diary (다이어리 내 메뉴)
- sub_gal_id (기본키) — number — Primary key — NOT NULL
- name (이름) — varchar
- private_yn (공개여부) — number
- codiary_yn (공동다이어리여부) — number
- homp_id (기본키2) — number — Foreign key → cy_minihome.homp_id — NOT NULL
- diary_id (기본키3) — number — Foreign key → cy_diary.diary_id — NOT NULL
cy_sub_galary (사진첩 내 메뉴)
- sub_gal_id (기본키) — number — Primary key — NOT NULL
- name (이름) — varchar
- private_yn (공개여부) — number
- order (순서) — number
- homp_id (기본키2) — number — Foreign key → cy_minihome.homp_id — NOT NULL
- galary_id (기본키3) — number — Foreign key → cy_galary.galary_id — NOT NULL
cy_user (횐)
- user_id (기본키) — number — Primary key — NOT NULL
- username (유저이름) — varchar
- loginid (아이디) — varchar
- passwd (비번) — varchar
- birth (생일) — date
- email (이멩리) — varchar
- gender (성별) — 1
emotion (감정)
- emotion_id (기본키) — number — Primary key — NOT NULL
- emo_con (내용) — varchar
visitor (방명록)
- visitor_id (기본키) — number — Primary key — NOT NULL
- content (내용) — varchar
- register_date (등록날짜) — date
- del_yn (삭제여부) — varchar
- homp_id (기본키2) — number — Foreign key → cy_minihome.homp_id — NOT NULL
- user_id (기본키3) — number — Foreign key → cy_user.user_id — NOT NULL
visitor_history (방문자로그남기는요)
- his_id (기본키) — number — Primary key — NOT NULL
- date (Field) — date
- homp_id (기본키2) — number — Foreign key → cy_minihome.homp_id — NOT NULL