ㅇㅇ

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