Study

Tables (5)

Coupon (Untitled3)

  • id (coupon_id) — int — Primary key — NOT NULL
  • id (uesr_id) — int — Foreign key → User.id — NOT NULL
  • 쿠폰 발급이력 (couponRecord) — boolean — NOT NULL
  • 사용 유무 (usageStatus) — boolean — NOT NULL
  • 할인코드 (code) — VARCHAR(45) — NOT NULL
  • 할인값 (discountValue) — VARCHAR(45) — NOT NULL
  • 할인종류 (discountType) — VARCHAR(45) — NOT NULL
  • 생성날짜 (createdAt) — TIMESTAMP — NOT NULL
  • 변경날짜 (updateAt) — TIMESTAMP — NOT NULL
  • 만료날짜 (endAt) — TIMESTAMP — NOT NULL
  • 지급날짜 (assignedAt) — TIMESTAMP — NOT NULL

PostComment (Untitled5)

  • id (postcomment_id) — int — Primary key — NOT NULL
  • id (study_id) — int — Foreign key → Study.id — NOT NULL
  • Field
  • Field2

Role (Untitled2)

  • id (Role_id) — int — Primary key — NOT NULL
  • id (user_id) — int — Foreign key → User.id — NOT NULL
  • 권한 (role) — VARCHAR(45)

Study (Untitled4)

  • id (study_id) — int — Primary key — NOT NULL
  • id (user_id) — int — Foreign key → User.id — NOT NULL
  • 제목 (title) — VARCHAR(45) — NOT NULL
  • 내용 (content) — VARCHAR(45) — NOT NULL
  • 스터디타입 (studyType) — VARCHAR(45) — NOT NULL
  • 생성날짜 (createdAt) — TIMESTAMP — NOT NULL
  • 변경날짜 (updateAt) — TIMESTAMP — NOT NULL

User (Untitled)

  • id (user_id) — int — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR(45) — NOT NULL
  • 비밀번호 (password) — VARCHAR(45) — NOT NULL
  • 권한 (role) — VARCHAR(45) — NOT NULL
  • 이름 (name) — VARCHAR(45) — NOT NULL
  • 생년월일 (birthday) — VARCHAR(45) — NOT NULL