TikkleMoa
Tables (7)
Board
- id — int — Primary key — NOT NULL
- title — VARCHAR(30)
- date — DATE
- content — TEXT
- img — TEXT — NOT NULL
- userid — Int — Foreign key → User.id — NOT NULL — autoIncrement
Calendar
- id — int — Primary key — NOT NULL
- date — DATE — YYYY-MM-DD
- category — ENUM — 수입 or 지출
- subcategory — VARCHAR(20) — front에서 값 선택
- price — int
- details — VARCHAR(100) — NOT NULL
- userid — Int — Foreign key → User.id — NOT NULL
Comment
- id — int — Primary key — NOT NULL
- date — DATE
- content — VARCHAR(100)
- boardid — int — Foreign key → Board.id — NOT NULL
- userid — Int — Foreign key → User.id — NOT NULL
Likes
- id — int — Primary key — NOT NULL
- boardid — int — Foreign key → Board.id — NOT NULL
- userid — Int — Foreign key → User.id — NOT NULL — autoIncrement
Post
- id — int — Primary key — NOT NULL
- title — VARCHAR(30)
- date — DATE
- content — TEXT
- img — TEXT — NOT NULL
- isRead — BOOLEAN
- senderDelete (senderDel) — BOOLEAN
- recipientDelete (recipientDel) — BOOLEAN
- serderid (senderid) — Int — Foreign key → User.id — NOT NULL — autoIncrement
- recipientid — Int — Foreign key → User.id — NOT NULL — autoIncrement
Setting
- id — int — Primary key — NOT NULL
- theme — VARCHAR(20)
- Level one (Lone) — int
- Level two (Ltwo) — int
- Level three (Lthree) — int
- priceView — boolean
- userid — Int — Foreign key → User.id — NOT NULL — autoIncrement
User
- id — Int — Primary key — NOT NULL — autoIncrement
- nickname — VARCHAR(20)
- userid — VARCHAR(20)
- userpw — TEXT — 암호화 저장
- img — TEXT — s3 url 데이터 저장
- badge — VARCHAR(20) — 이름만 저장, 이미지는 따로 저장 후 이름에 따라 꺼내오기