1팀_학원의민족ERD
테이블 (13)
academy
- academy_id — int(11) — 기본 키 — NOT NULL — pk
- academy_name — varchar(255)
- academy_address — varchar(255)
- target_group — int(11) — fk : target_group(group_id)
- course_id — int(11) — fk : course(course_id)
- academy_home_img — varchar(255)
- academy_phone — varchar(20)
- academy_email — varchar(255)
- category_id — int(11) — fk : category(category_id)
- academy_description — text
- academy_created_at — datetime
- academy_updated_at — datetime
- academy_status — enum('pending', 'approved', 'rejected')
cart
- cart_id — int(11) — 기본 키 — NOT NULL — pk
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL — fk
- academy_id — int(11) — fk
- course_id — int(11) — fk
- quantity — int(11)
- cart_added_at — datetime
cart_item
- cart_item_id — int(11) — 기본 키 — NOT NULL — pk
- cart_id — int(11) — 외래 키 → cart.cart_id — NOT NULL — fk
- member_id — int(11) — 외래 키 → cart.member_id — NOT NULL — fk
- course_id — int(11) — fk
- item_price — decimal(10, 2)
- item_status — varchar(50)
course
- course_id — int(11) — 기본 키 — NOT NULL — pk
- academy_id — int(11) — 외래 키 → academy.academy_id — NOT NULL — fk : academy(academy_id)
- course_name — varchar(255)
- course_description — text
- course_price — decimal(10, 2)
- course_duration — int(11)
- course_start_date — datetime
- course_created_at — datetime
- course_updated_at — datetime
enrollment
- enrollment_id — int(11) — 기본 키 — NOT NULL — pk
- member_id2 — int(11) — 외래 키 → member.member_id — NOT NULL — fk : member(member_id)
- member_address_id2 — int(11) — 외래 키 → member.member_address_id — NOT NULL — pk
- academy_id — int(11) — fk : academy(academy_id)
- course_id — int(11) — fk : course(course_id)
- course_status — enum('pending', 'approved', 'cancelled')
- course_created_at — datetime
- course_updated_at — datetime
favorite
- favorite_id — int(11) — 기본 키 — NOT NULL — pk
- course_id — int(11) — 외래 키 → course.course_id — NOT NULL — fk
- academy_id — int(11) — 외래 키 → course.academy_id — NOT NULL — fk : academy(academy_id)
- favorie_created_at — datetime
- memeber_id — int(11) — fk
- Field — VARCHAR(255)
inbox_message
- message_id — int — 기본 키 — NOT NULL — pk
- sender_type — enum('member', 'academy_admin')
- sender_id — int
- receiver_type — enum('member', 'academy_admin')
- receiver_id — int
- message_content — text
- sent_at — datetime
- message_read_status — tinyint(1) — 0=안읽음, 1=읽음
- Field8 — VARCHAR(255)
instructor
- instructor_id — int(11) — 기본 키 — NOT NULL — pk
- instructor_name — course_id
- course_id2 — int(11) — NOT NULL — fk
- academy_id — int(11) — NOT NULL — fk : academy(academy_id)
login_id
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL — fk : member(member_id)
- nickname — varchar(255)
- password — varchar(255)
- id — varchar(255)
member
- member_id — int(11) — 기본 키 — NOT NULL — pk
- member_address_id — int(11) — 외래 키 → member_address.member_address_id — NOT NULL — fk : member_address(member_address_id)
- member_name — varchar(*100) — NOT NULL
- gender — int(11) — NOT NULL
- member_age — varchar(10) — NOT NULL
- member_type_id — enum('user', 'acad') — acad = academy admin
- member_email — varchar(255)
- member_phone — varchar(20)
- phone_verified — boolean
- member_created_at — datetime
- member_updated_at — datetime
- gps_enabled — tinyint(1) — 1=허용, 0=비허용
- member_attachment — varchar(255)
member_address
- member_address_id — int(11) — 기본 키 — NOT NULL — pk
- address1 — varchar(255)
- address2 — varchar(255)
- city — var(50)
- state — var(50)
- zipcode — int(50)
- last_update — datetime
payment
- payment_id — int(11) — 기본 키 — NOT NULL — pk
- member_id2 — int(11) — 외래 키 → member.member_id — NOT NULL — pk
- member_address_id2 — int(11) — 외래 키 → member.member_address_id — NOT NULL — pk
- enrollment_id — int(11)
- member_id — int(11)
- amount — decimal(10, 2)
- payment_date — payment_date
- status — enum('success', 'failed', 'pending')
review
- reviews_id — int(11) — 기본 키 — NOT NULL — pk
- member_id — int(11) — 외래 키 → member.member_id — NOT NULL — fk : member(member_id)
- member_address_id — int(11) — 외래 키 → member.member_address_id — NOT NULL — fk : member(member_address_id)
- course_id — int(11) — fk : course(course_id)
- content — text
- rating — tinyint
- review_created_at — datetime
- review_updated_at — datetime
- academy_id — int(11) — NOT NULL — fk : academy(academy_id)
- academy_id2 — int(11) — NOT NULL — fk : academy(academy_id)