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) — 이름만 저장, 이미지는 따로 저장 후 이름에 따라 꺼내오기