jes-first-dev

Tables (12)

artisan_goods (Untitled12)

  • Key (item_id) — int — Primary key — NOT NULL
  • Field (item_name) — varchar(30)
  • Field (item_name_kr) — varchar(30)
  • Field (item_type) — ENUM('crop','fish','mineral','product','artisan_goods')
  • Field (base_produce_id) — int
  • Field (machine_name) — varchar(30)
  • Field (processing_time) — int
  • Field (sell_price) — varchar(30)
  • Field (energe_recovery) — varchar(50)
  • Field (health_recovery) — varchar(50)

bundleItems (bundleitems)

  • Key (bundle_item_id) — int — Primary key — NOT NULL
  • Key (bundle_id) — int — Foreign key → bundles.Key — NOT NULL
  • Field (item_id) — int
  • Field (item_type) — ENUM('crop','fish','mineral','product','artisan_goods')
  • Field (quantity) — int

bundles (Untitled3)

  • Key (bundle_id) — int — Primary key — NOT NULL
  • Key (room_id) — int — Foreign key → rooms.Key — NOT NULL
  • Field (bundle_name) — varchar(50)

crops

  • Key (item_id) — int — Primary key — NOT NULL
  • Field (item_name) — varchar(30)
  • Field (item_name_kr) — varchar(30)
  • Field (item_type) — ENUM('crop','fish','mineral','product','artisan_goods')
  • Field (season) — varchar(30)
  • Field (seed_name) — varchar(30)
  • Field (seed_name_kr) — varchar(30)
  • Field (seed_price) — int
  • Field (harvest_time) — int
  • Field (regrowth) — int
  • Field (sell_price) — varchar(50)
  • Field (energe_recovery) — varchar(50)
  • Field (health_recovery) — varchar(50)

fishes

  • Key (item_id) — int — Primary key — NOT NULL
  • Field (item_name) — varchar(30)
  • Field (item_name_kr) — varchar(30),
  • Field (item_type) — ENUM('crop','fish','mineral','product','artisan_goods')
  • Field (location) — varchar(50)
  • Field (time_of_day) — varchar(20)
  • Field (season) — varchar(30)
  • Field (weather) — varchar(20)
  • Field (size_range) — varchar(20)
  • Field (difficulty) — int
  • Field (sell_price) — varchar(50)
  • Field (energe_recovery) — varchar(50)
  • Field (health_recovery) — varchar(50)

minerals (Untitled10)

  • Key (item_id) — int — Primary key — NOT NULL
  • Field (item_name) — varchar(30)
  • Field (item_name_kr) — varchar(30)
  • Field (item_type) — ENUM('crop','fish','mineral','product','artisan_goods')
  • Field (base_product_id) — int
  • Field (machine_name) — varchar(50)
  • Field (processing_time) — int
  • Field (sell_price) — varchar(50)
  • Field (energe_recovery) — varchar(50)
  • Field (health_recovery) — varchar(50)

npc (Untitled6)

  • Key (npc_id) — int — Primary key — NOT NULL
  • Field (npc_name) — varchar(30)
  • Field (npc_name_kr) — varchar(30)
  • Field (npc_gender) — int
  • Field (npc_marry_possible) — boolean
  • Field (birthday) — int

npc_gifts (Untitled7)

  • Key (gift_id) — int — Primary key — NOT NULL
  • Field (preference) — ENUM('love','like','dislike','hate','netural')

products (Untitled11)

  • Key (item_id) — int — Primary key — NOT NULL
  • Field (item_name) — varchar(30)
  • Field (item_name_kr) — varchar(30)
  • Field (item_type) — ENUM('crop','fish','mineral','product','artisan_goods')
  • Field (source) — varchar(50)
  • Field (season) — varchar(20)
  • Field (sell_price) — varchar(50)
  • Field (energe_recovery) — varchar(50)
  • Field (health_recovery) — varchar(50)

rewards (Untitled5)

  • Key (reward_id) — int — Primary key — NOT NULL
  • Key (bundle_id) — int — Foreign key → bundles.Key — NOT NULL
  • Field (reward_name) — varchar(50)
  • Field (reward_amount) — int

rooms (Untitled2)

  • Key (room_id) — int — Primary key — NOT NULL
  • Field (room_name) — varchar(32)
  • Field (room_reward) — varchar(50)

users (Untitled)

  • Key (id) — int — Primary key — NOT NULL
  • Field (userId) — varchar(32)
  • Field (userPassword) — varchar(32)
  • Field (nickname) — varchar(32)
  • Field (createdAt) — timestamp
  • Field (updatedAt) — timestamp
  • Field (userType) — ENUM('admin','user','guest')
  • Field (lastLoginAt) — timestamp
  • Field (deletedAt) — timestamp