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