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