dotori

자바를 자바라팀의 dotori프로젝트 erd

테이블 (13)

friends_list (Untitled5)

  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • friend_id (Field)

member (Untitled)

  • member_id (Key) — 기본 키 — NOT NULL
  • member_pwd (Field)
  • member_name (Field2)
  • nickname (Field3)
  • birth_date (Field4)
  • gender (Field5)
  • phone (Field6)
  • address (Field7)
  • dotori (Field8)
  • enroll_date (Field9)

minihome (Untitled2)

  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • today (Field)
  • total (Field2)
  • background_img_code (Field3)

minihome_album (Untitled11)

  • member_id (Key22) — 외래 키 → minihome.member_id — NOT NULL
  • title (Field)
  • url (Field2)
  • description (Field3)
  • profile_yn (Field4)

minihome_board (Untitled7)

  • member_id (Key22) — 외래 키 → minihome.member_id — NOT NULL
  • friend_id (Field)
  • title (Field2)
  • content (Field3)
  • date (Field4)

minihome_diary (Untitled8)

  • member_id (Key22) — 외래 키 → minihome.member_id — NOT NULL
  • date (Field)
  • content_code (Field2)
  • content (Field3)
  • frined_id (Field4)
  • comment (Field5)

minihome_jukebox (Untitled6)

  • member_id (Key22) — 외래 키 → minihome.member_id — NOT NULL
  • music_code (Field)
  • play_seq (Field2)
  • category (Field3)

minimi (Untitled9)

  • minimi_item_code (Key) — 기본 키 — NOT NULL
  • url (Field)
  • price (Field2)

minimi_purchase_list (Untitled14)

  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • minimi_item_code (Key3) — 외래 키 → minimi.minimi_item_code — NOT NULL
  • sort (Field)

music (Untitled4)

  • music_code (Key) — 기본 키 — NOT NULL
  • url (Field)
  • price (Field2)

music_purchase_list (Untitled13)

  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • music_code (Key3) — 외래 키 → music.music_code — NOT NULL

skin_item (Untitled3)

  • skin_item_code (Field) — 기본 키
  • url (Field2)
  • price (Field3)

skin_purchase_list (Untitled12)

  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • skin_item_code (Field5) — 외래 키 → skin_item.skin_item_code
  • sort (Field)