b4

Tables (11)

News (Untitled7)

  • Key (id) — bigint — Primary key — NOT NULL
  • pid_id (id2) — bigint — Foreign key → PId.id — NOT NULL
  • title — varchar
  • body — varchar
  • detail — varchar
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp

PId (Untitled6)

  • id — bigint — Primary key — NOT NULL
  • title — varchar
  • content (category) — text
  • category (content) — varchar
  • created_at — timestamp
  • updated_at — timestamp

app_user (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar
  • introduction (Field2) — varchar
  • name (Field3) — varchar
  • nickname (Field4) — varchar
  • password (Field5) — varchar
  • password_code (Field6) — varchar
  • profile_pic_url (Field7) — text
  • provider (Field8) — varchar
  • provider_id (Field9) — varchar
  • role (Field10) — varchar
  • status (Field11) — varchar
  • tlno (Field12) — varchar
  • verification_code (Field13) — varchar
  • created_at (Field14) — timestamp
  • updated_at (Field15) — timestamp

board (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → app_user.id — NOT NULL
  • title (Field) — varchar
  • name (Field2) — varchar
  • content (Field3) — varchar
  • image (Field4) — varchar
  • count (Field5) — varchar
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp

board_like_user (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • board_id (Key3) — bigint — Foreign key → board.id — NOT NULL
  • user_id (Key22) — bigint — Foreign key → board.user_id — NOT NULL
  • like_status (Field) — boolaen

comment (Untitled4)

  • id (Key3) — bigint — Primary key — NOT NULL
  • board_id (Key) — bigint — Foreign key → board.id — NOT NULL
  • user_id (Key2) — bigint — Foreign key → board.user_id — NOT NULL
  • count (Field) — int
  • content (Field2) — varchar
  • name (Field3) — varchar

marsover (Untitled10)

  • id (Key) — bigint — Primary key — NOT NULL
  • camera_name (Field) — varchar
  • earth_date (Field2) — varchar
  • img_src (Field3) — varchar
  • rover_name (Field4) — varchar

message (Untitled9)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → app_user.id — NOT NULL
  • title (Field) — varchar
  • content (Field2) — varchar
  • deleted_by_receiver (Field3) — boolaen
  • deleted_by_sender (Field4) — boolaen

nasaimages (Untitled11)

  • id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar
  • url (Field2) — varchar
  • service_version (Field3) — varchar
  • media_type (Field4) — varchar
  • hdurl (Field5) — varchar
  • explanation (Field6) — text
  • date (Field7) — date

refresh_tokens (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → app_user.id — NOT NULL
  • token (Field) — varchar

user_recent_password (Untitled8)

  • Key — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → app_user.id — NOT NULL