am

Tables (5)

member (사용자)

  • id (식별자) — NOT NULL — Primary key — NOT NULL
  • email (이메일) — NOT NULL
  • nickname (닉네임) — NOT NULL
  • password (패스워드) — NOT NULL

member_role (역할)

  • member_role (역할) — NOT NULL
  • member_id (식별자) — NOT NULL — Foreign key → member.id — NOT NULL

purchase (구매)

  • purchase_id (구매식별자) — bigint(20) — Primary key — NOT NULL
  • purchase_date (구매일자) — date
  • Field

rental (렌탈)

  • rental_id (렌탈식별자) — bigint(20) — Primary key — NOT NULL
  • code (렌탈코드) — varchar(100)
  • fee (요금) — int
  • type (유형) — varchar(100)
  • spec (스펙) — varchar(100)
  • rent_start (렌탈시작일) — date
  • rent_end (렌탈종료일) — date
  • member_id (식별자) — NOT NULL — Foreign key → member.id — NOT NULL

rental_hist (대여이력)

  • member_id (bigint(20)) — NOT NULL — Foreign key → member.id — NOT NULL