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