assignment
Tables (8)
features (맴버쉽기능)
- id (Key) — BIGINT — Primary key — NOT NULL
- feature_name (Field) — VARCHAR(30)
- created_at (Field2) — DATETIME
- updated_at (Field3) — DATETIME
membership (맴버쉽)
- Key — BIGINT — Primary key — NOT NULL
- period (Field) — INT
- level (Field2) — VARCHAR(30)
- is_deleted (Field3) — TINYINT
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
membership_features (맴버쉽-맴버쉽기능-매핑테이블)
- id (Key) — BIGINT — Primary key — NOT NULL
- features_id (FK1) — BIGINT — Foreign key → features.id — NOT NULL
- memebership_id (FK2) — BIGINT — Foreign key → membership.Key — NOT NULL
payment_log (결제기록)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (FK) — BIGINT — Foreign key → user.id — NOT NULL
- card_issuer (Field) — VARCHAR(30)
- payment_amount (Field2) — BIGINT
- created_at (Field3) — DATETIE
- updated_at (Field4) — DATETIME
- peyment_id (Field5) — VARCHAR(50)
- payment_state (Field6) — VARCHAR(50)
user (유저)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(30)
- name (Field2) — VARCHAR(30)
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
- is_deleted (Field5) — TINY INT
- role (Field6) — VARCHAR(30)
user_membership (유저-맴버쉽-매핑테이블)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (FK1) — BIGINT — Foreign key → user.id — NOT NULL
- membership_id (FK2) — BIGINT — Foreign key → membership.Key — NOT NULL
- payment_log_id (FK3) — BIGINT — Foreign key → payment_log.id — NOT NULL
- created_at (Field) — DATETIME
- expired_date (Field2) — DATETIME
user_membership_read_features (유저 멤버쉽 기능 읽기전용테이블)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_membership_read_id (FK) — BIGINT — Foreign key → user_membership_reads.id — NOT NULL
- feature_id (Field) — BIGINT
- feature_name (Field2) — VARCHAR(255)
- feature_key (Field3) — VARCHAR(255)
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
- deleted_at (Field6) — DATETIME
user_membership_reads (유저 멤버쉽 읽기전용 테이블)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Field) — BIGINT
- membership_id (Field2) — BIGINT
- expired_date (Field3) — DATETIME
- membership_period (Field4) — INT
- membership_price (Field5) — INT
- deleted_at (Field6) — DATETIME
- created_at (Field7) — DATETIME
- updated_at (Field8) — DATETIME