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