chp.0

Tables (8)

alarm

  • id — BIGINT — Primary key — NOT NULL
  • alarm_type — ENUM('NOTICE','REMINDER')
  • alarm_message — VARCHAR(512)
  • title — VARCHAR(256)
  • content — TEXT
  • sender_id — BIGINT
  • receiver_id — BIGINT
  • created_at — DATE
  • updated_at — DATE

alarm_setting

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • fire_enabled — BOOLEAN — NOT NULL
  • reminder_enabled — BOOLEAN — NOT NULL
  • reminder_time — DATETIME
  • created_at — DATE
  • updated_at — DATE

diary

  • id — BIGINT — Primary key — NOT NULL
  • content — TEXT
  • emotion — ENUM('HAPPY','ANGRY')
  • record_date — DATE
  • member_id — BIGINT — NOT NULL
  • created_at — DATE
  • updated_at — DATE

friend

  • id — BIGINT — Primary key — NOT NULL
  • friend_status — ENUM('REJECTED','ACCEPTED') — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • receiver_id — BIGINT — NOT NULL
  • created_at — DATE
  • updated_at — DATE

member

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • email — VARCHAR(100)
  • user_id — VARCHAR(125)
  • nickname — VARCHAR(50)
  • reward — INT
  • feeling — VARCHAR(100)
  • introduction — VARCHAR(256)
  • created_at — DATE
  • updated_at — DATE

member_answer

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • question_id — BIGINT — NOT NULL
  • content — VARCHAR(512)
  • created_at — DATE
  • updated_at — DATE

member_item

  • id — BIGINT — Primary key — NOT NULL
  • item — ENUM('FISH') — NOT NULL
  • member_id — BIGINT — NOT NULL
  • created_at — DATE
  • updated_at — DATE

question

  • id — BIGINT — Primary key — NOT NULL
  • content — VARCHAR(256) — NOT NULL
  • created_at — DATE
  • updated_at — DATE