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)