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)